Re: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

2008-04-09 Thread Raymond O'Donnell
On 09/04/2008 11:50, Peter Geoghegan wrote: I recall that in earlier versions of the PostgreSQL windows binary distribution, I had finer grained control of what modules were installed. The only optional module is now PL/Java, which I don't use, and things like headers and libraries. I cannot spe

Re: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

2008-04-09 Thread Dave Page
On Wed, Apr 9, 2008 at 12:22 PM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Peter Geoghegan wrote: > > > Richard, > > > > I recall that in earlier versions of the PostgreSQL windows binary > > distribution, I had finer grained control of what modules were > > installed. The only optional module is

Re: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

2008-04-09 Thread Richard Huxton
Peter Geoghegan wrote: Richard, I recall that in earlier versions of the PostgreSQL windows binary distribution, I had finer grained control of what modules were installed. The only optional module is now PL/Java, which I don't use, and things like headers and libraries. I cannot specify install

Re: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

2008-04-09 Thread Peter Geoghegan
Richard, I recall that in earlier versions of the PostgreSQL windows binary distribution, I had finer grained control of what modules were installed. The only optional module is now PL/Java, which I don't use, and things like headers and libraries. I cannot specify installing Pl/PgSQL, Pl/Perl etc

Re: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

2008-04-09 Thread Richard Huxton
Peter Geoghegan wrote: Hello, I'm developing a large postgreSQL database front end application on win32. I'd consider the ability to debug Pl/PgSQL functions highly desirable. Until now, I've been using RAISE NOTICE debugging, which is equivalent to printf debugging, and is sub optimal. "Sub o

Re: [GENERAL] Debugging PL/pgSQL

2005-06-21 Thread Sean Davis
Ah, yes  I should have qualified my statement a bit.  Sorry if I was misleading   Sean   - Original Message - From: Bob To: Sean Davis Cc: Craig Bryden ; pgsql Sent: Tuesday, June 21, 2005 4:57 PM Subject: Re: [GENERAL] Debugging PL/pgSQL Keep in

Re: [GENERAL] Debugging PL/pgSQL

2005-06-21 Thread Bob
Keep in mind there is no built in API to debug PL/pgSQL like there is for PL/SQL. You will have to use the old true and tried output statements to debug your stored procs. On 6/21/05, Sean Davis <[EMAIL PROTECTED]> wrote: You might want to look at pgEdit.Sean- Original Message -From: "Craig

Re: [GENERAL] Debugging PL/pgSQL

2005-06-21 Thread Sean Davis
You might want to look at pgEdit. Sean - Original Message - From: "Craig Bryden" <[EMAIL PROTECTED]> To: "pgsql" Sent: Tuesday, June 21, 2005 3:01 PM Subject: [GENERAL] Debugging PL/pgSQL Hi Does anyone know of a free SQL Editor that allows you to debug PL/pgSQL functions? Than