Re: BUG #6722: Debugger broken?

Hi

On Mon, Jul 9, 2012 at 12:58 PM,  <jan-peter.seifert@gmx.de> wrote:
> 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:
>
> 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-usin=
g-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:\Progr=
am
> Files\PostgreSQL\9.1\share\contrib\pldbgapi.sql
>
> I only get a function not found ( in debugger.dll ) error:
>
> FEHLER: konnte Funktion =BBplpgsql_oid_debug=AB nicht in Datei =BBC:/Prog=
ram
> Files/PostgreSQL/9.1/lib/plugins/plugin_debugger.dll=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.

It looks like it got broken as a result of this commit:
http://git.postgresql.org/gitweb/?p=3Dpldebugger.git;a=3Dcommit;h=3D54d993c=
04809da7cda79013a55b679a615c7dce1

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.

--=20
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company