Re: Debugging plpgsql functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darren Ferguson <darren(at)crystalballinc(dot)com>
Cc: Tomáš Vondra <vondra(at)tesmail(dot)cz>, PostgreSQL Mailing Lists-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Debugging plpgsql functions
Date: 2002-09-09 16:56:33
Message-ID: 11861.1031590593@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Darren Ferguson <darren(at)crystalballinc(dot)com> writes:
> RAISE NOTICE is your friend for debugging plpgsql functions

Yeah, that's almost the only tool at the moment. A real debugger, or
even just a trace facility, for plpgsql would be a huge improvement in
usability. We've batted the idea around once or twice I think, but no
one's tried to design or implement one.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-09-09 17:18:01 Re: AutoCommit mode in PostgreSQL (7.3 beta1 from CVS 05.09.2002)
Previous Message Jan Ploski 2002-09-09 16:47:55 Re: Creating tons of tables to support a query