The following bug has been logged on the website:
Bug reference: 6722
Logged by: Jan-Peter Seifert
Email address: jan-peter.seifert@gmx.de
PostgreSQL version: 9.1.4
Operating system: Windows 7 Enterprise (64-bit)
Description:=20=20=20=20=20=20=20=20
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=3Dpldebugger.git;a=3Dlog
I activated the debugger in postgresql.conf and restarted the server(s)):
shared_preload_libraries =3D '$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 =C2=BBplpgsql_oid_debug=C2=AB nicht in Datei =C2=BB=
C:/Program
Files/PostgreSQL/9.1/lib/plugins/plugin_debugger.dll=C2=AB 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.
With best regards,
Peter
