Re: PostgreSQL 9.6.1: Debug window does not load function sql

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>