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