Обсуждение: [GENERAL] PostgreSQL 9.6.1: Debug window does not load function sql
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.
Any help is appreciated.
Thanks
Shakti Singh
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
Thanks Adrian,
![Inline image 1](/media/maillist_attaches/pgsql-general/2016/12/14/CAH19PkmwBGK_ZQZCzZ4E_-oAm1umFSy=iYCXqVWKUJboUJxkdA@mail.gmail.com/image.png)
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](/media/maillist_attaches/pgsql-general/2016/12/14/CAH19PkmwBGK_ZQZCzZ4E_-oAm1umFSy=iYCXqVWKUJboUJxkdA@mail.gmail.com/image.png)
Thanks,
Shakti Singh
On Wed, Dec 14, 2016 at 9:45 AM, Adrian Klaver <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
"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
Вложения
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> > > "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
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:
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 Klaveradrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.<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>
"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 Klavercom>
--
Adrian Klaver
adrian.klaver@aklaver.com