Debugging plpgsql functions
Hello everybody,
is it posssible to use "debugging" on a PostgreSQL server, at least
for stored procedures. Is there some possibility to use
breakpoints,, watches etc?
For example when I'm programming stored procedure on my
workstation, and I want to use it on a database server, is there a
possibility for some advanced debugging?
I haven't found IDE or editor supporting this feature, but I don't
know if it's caused by impossibility to implement this.
Tomas
RAISE NOTICE is your friend for debugging plpgsql functions
On Mon, 9 Sep 2002, [ISO-8859-2] Tom� Vondra wrote:
Hello everybody,
is it posssible to use "debugging" on a PostgreSQL server, at least
for stored procedures. Is there some possibility to use
breakpoints,, watches etc?For example when I'm programming stored procedure on my
workstation, and I want to use it on a database server, is there a
possibility for some advanced debugging?I haven't found IDE or editor supporting this feature, but I don't
know if it's caused by impossibility to implement this.Tomas
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Darren Ferguson
Darren Ferguson <darren@crystalballinc.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