Hi On Mon, Jul 9, 2012 at 12:58 PM, <jan-peter.seif...@gmx.de> wrote: > The following bug has been logged on the website: > > Bug reference: 6722 > Logged by: Jan-Peter Seifert > Email address: jan-peter.seif...@gmx.de > PostgreSQL version: 9.1.4 > Operating system: Windows 7 Enterprise (64-bit) > Description: > > Hello, > > it seems that the debugger doesn't work with current minor versions of > PostgreSQL. > > I don't even get the debugging option shown here: > http://stackoverflow.com/questions/7865615/debug-postgresql-function-using-pgadmin > > It could be connected to these changes: > http://git.postgresql.org/gitweb/?p=pldebugger.git;a=log > > I activated the debugger in postgresql.conf and restarted the server(s)): > shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' > > As there only exists the contrib-script I tried to execute this: c:\Program > Files\PostgreSQL\9.1\share\contrib\pldbgapi.sql > > I only get a function not found ( in debugger.dll ) error: > > FEHLER: konnte Funktion »plpgsql_oid_debug« nicht in Datei »C:/Program > Files/PostgreSQL/9.1/lib/plugins/plugin_debugger.dll« finden > SQL Status:42883 > > If I switch to this it works: > CREATE OR REPLACE FUNCTION pldbg_oid_debug( OID ) RETURNS INTEGER AS > '$libdir/plugins/plugin_debugger' LANGUAGE C STRICT; > > It's the same with 8.4.12 ( 32-bit ) and 9.0.8 ( 64-bit ). It's the very > same install script for each version. > In 8.4.12 I also have these two files: > c:\Program Files (x86)\PostgreSQL\8.4\share\contrib\pldbgapi--1.0.sql > and > c:\Program Files > (x86)\PostgreSQL\8.4\share\contrib\pldbgapi--unpackaged--1.0.sql > Obviously they are for PostgreSQL 9.1. > The first says install with 'CREATE EXTENSION pldbgapi' > There's no such extension - neither in Windows nor Ubuntu ( One click > installer and aptitude ) nor in the docs.
It looks like it got broken as a result of this commit: http://git.postgresql.org/gitweb/?p=pldebugger.git;a=commit;h=54d993c04809da7cda79013a55b679a615c7dce1 Dharmendra; can you please take a look at this? A quick look at my 9.1 installation shows that the control file is missing along with the SQL scripts. I only have the old pre-extension SQL script from the previous point release (that should really be deleted). For 8.4/9.0 of course, the old installation technique should be used. Please also ensure the docs are appropriate for all branches. Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
