Re: [GENERAL] newbie debugging pl/pgsql : better way?

2000-10-25 Thread Tom Lane
Ashley Clark <[EMAIL PROTECTED]> writes: >> Is there a better way to debug pl/pgsql functions? > If you find it let me know. The postmaster log should have useful tidbits. Make sure there *is* a postmaster log --- start the postmaster without -S, and with its stdout and stderr directed into a l

Re: [GENERAL] newbie debugging pl/pgsql : better way?

2000-10-24 Thread Ashley Clark
* Frank Miles in "[GENERAL] newbie debugging pl/pgsql : better way?" * dated 2000/10/24 11:56 wrote: > I have a simple function that isn't working. I've enabled debugging, > but the error message is still mystifying. My function is as > follows: > >

[GENERAL] newbie debugging pl/pgsql : better way?

2000-10-24 Thread Frank Miles
I have a simple function that isn't working. I've enabled debugging, but the error message is still mystifying. My function is as follows: CREATE FUNCTION proj_name(int) RETURNS char(7) AS ' DECLARE prn ALIAS FOR $1; precrec