Re: Has anyone tried out the PL/pgSQL debugger?

On Sep 4, 2007, at 1:01 PM, korry.douglas wrote:

> The core of the debugger has been in use for quite some time, but I
> had to strip out a lot of EDB-specific code and I'd like to see
> that the result (the open-source version at pgFoundry) holds up
> well on other platforms.
> Josh, any chance you could try it out on Solaris?

I copied the latest from pgFoundry to my contrib folder (pg 8.2.1)
and executed 'make; make install'. I get the following errors on OS X
10.4.10:

plugin_profiler.c: In function 'tableExists':
plugin_profiler.c:698: error: too few arguments to function
'stringToQualifiedNameList'
plugin_profiler.c: In function 'dumpStatsXML':
plugin_profiler.c:847: warning: format '%07ld' expects type 'long
int', but argument 4 has type 'suseconds_t'
plugin_profiler.c:850: warning: format '%07ld' expects type 'long
int', but argument 4 has type 'suseconds_t'
make: *** [plugin_profiler.o] Error 1
rm plugin_debugger.o targetinfo.o pldbgapi.o
Makefile:63: warning: overriding commands for target `install'
../../src/makefiles/pgxs.mk:104: warning: ignoring old commands for
target `install'
Makefile:77: warning: overriding commands for target `installdirs'
../../src/makefiles/pgxs.mk:139: warning: ignoring old commands for
target `installdirs'
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -DINCLUDE_PACKAGE_SUPPORT=0 -I../../src/pl/plpgsql/src -I.
-I../../src/include -c -o plugin_profiler.o plugin_profiler.c
plugin_profiler.c: In function 'tableExists':
plugin_profiler.c:698: error: too few arguments to function
'stringToQualifiedNameList'
plugin_profiler.c: In function 'dumpStatsXML':
plugin_profiler.c:847: warning: format '%07ld' expects type 'long
int', but argument 4 has type 'suseconds_t'
plugin_profiler.c:850: warning: format '%07ld' expects type 'long
int', but argument 4 has type 'suseconds_t'
make: *** [plugin_profiler.o] Error 1

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL