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.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@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> >> >> "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/plugi >> n_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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
