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