PostgreSQL 9.6.1: Debug window does not load function sql

On 12/14/2016 05:19 AM, Shakti Singh wrote:

Hi,

I am working on a POC to port Oracle database to PostGreSQL.
I am trying to debug a function in pgAdmin 4 after enabling debugger.

The Debugger window that opens in pgAdmin 4 for a function does not show
any function code because of which I cannot put a break point.

Does all of the below apply to your situation?:

https://www.pgadmin.org/docs4/dev/debugger.html

"The debugger may be used to debug PL/pgSQL functions in PostgreSQL, as
well as EDB-SPL functions, stored procedures and packages in Advanced
Server. The Debugger is available as an extension for your PostgreSQL
installation, and is distributed as part of Advanced Server. You must
have superuser privileges to use the debugger.

Before using the debugger, you must modify the postgresql.conf file,
adding the server-side debugger components to the the value of the
shared_preload_libraries parameter:

shared_preload_libraries = ‘$libdir/other_libraries/plugin_debugger’

After modifying the shared_preload_libraries parameter, restart the
server to apply the changes."

Any help is appreciated.

Thanks

Shakti Singh

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thanks Adrian,

Yes, I did all this. The OS is Windows 2012 R2 64 bit.

I am logging in using postgres user, which is the super user for the
database.

The shared_preload_libraries = '$libdir/plugin_debugger' (The dll resides
in the "lib" directory)

I restarted the server by restarting the service "postgresql-x64-9.6 -
PostgreSQL Server 9.6"

Here is the screenshot of the right hand pane when:

1. I select a plpgsql function
2. right click and select Debugging > Debug
3. Fill in the parameter values in the pop up

[image: Inline image 1]

Thanks,

Shakti Singh

On Wed, Dec 14, 2016 at 9:45 AM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 12/14/2016 09:38 AM, Shakti Singh wrote:

Thanks Adrian,

Yes, I did all this. The OS is Windows 2012 R2 64 bit.

I am logging in using postgres user, which is the super user for the
database.

The shared_preload_libraries = '$libdir/plugin_debugger' (The dll
resides in the "lib" directory)

I restarted the server by restarting the service "postgresql-x64-9.6 -
PostgreSQL Server 9.6"

Here is the screenshot of the right hand pane when:

1. I select a plpgsql function
2. right click and select Debugging > Debug
3. Fill in the parameter values in the pop up

Inline image 1

Seems there are some bug reports on this, see below. You will need to
sign up for a Postgres community account to see/add to the issues though:

https://www.postgresql.org/account/signup/

Issue reports:

https://redmine.postgresql.org/issues/2022
https://redmine.postgresql.org/issues/2018

Thanks,

Shakti Singh

On Wed, Dec 14, 2016 at 9:45 AM, Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

On 12/14/2016 05:19 AM, Shakti Singh wrote:

Hi,

I am working on a POC to port Oracle database to PostGreSQL.
I am trying to debug a function in pgAdmin 4 after enabling
debugger.

The Debugger window that opens in pgAdmin 4 for a function does
not show
any function code because of which I cannot put a break point.

Does all of the below apply to your situation?:

https://www.pgadmin.org/docs4/dev/debugger.html
<https://www.pgadmin.org/docs4/dev/debugger.html&gt;

"The debugger may be used to debug PL/pgSQL functions in PostgreSQL,
as well as EDB-SPL functions, stored procedures and packages in
Advanced Server. The Debugger is available as an extension for your
PostgreSQL installation, and is distributed as part of Advanced
Server. You must have superuser privileges to use the debugger.

Before using the debugger, you must modify the postgresql.conf file,
adding the server-side debugger components to the the value of the
shared_preload_libraries parameter:

shared_preload_libraries = ‘$libdir/other_libraries/plugin_debugger’

After modifying the shared_preload_libraries parameter, restart the
server to apply the changes."

Any help is appreciated.

Thanks

Shakti Singh

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thanks Adrian,

This is exactly what I am experiencing.

I will track these issues for resolution.

Shakti Singh

On Wed, Dec 14, 2016 at 2:59 PM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote: