Обсуждение: 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