I have written an article about PostgreSQL function debugging environment. The source code of PostgreSQL 9.1.3plpgsqldebuggermodule is old, and many PG codes are migrated to g.
I have previously written an article about PostgreSQL 9.1.3 plpgsql debugger module, which is set up in the PostgreSQL function debugging environment. The source code is old and many PG codes are moved to g
I have previously written an article about how to build a PostgreSQL function debugging environment.
PostgreSQL 9.1.3 plpgsql debugger module
The source code is old, and many PG code has been moved to github, which also contains pldebugger. This BLOG still describes how to set up the function debugging environment, just get the source code of pldebugger from GITHUB.
1. Install the git client first,
Git Installation Reference
Git install
2. Get source code
Cloning into 'pldebucket '...
Remote: Counting objects: 366, done.
Remote: Compressing objects: 100% (262/262), done.
Remote: Total 366 (delta 233), reused 171 (delta 104)
Grouping objects: 100% (366/366), 158.87 KiB | 3 KiB/s, done.
Resolving deltas: 100% (233/233), done.
2. Installation (PostgreSQL 9.2 beta2 source code is used for testing)
Make
Sudo make install
3. Load modules
CREATE EXTENSION
4. debug plpgsql Functions
Omitted,
See
,