Postgres Pro
Downloads
Home   >   mailing lists

Re: pl/SQL debugging in PostgreSQL - Mailing list pgsql-novice

From Tom Lane
Subject Re: pl/SQL debugging in PostgreSQL
Date
Msg-id 26170.1548427367@sss.pgh.pa.us
Whole thread Raw
In response to pl/SQL debugging in PostgreSQL  (Michael Holzman <michaelholzman@gmail.com>)
Responses Re: pl/SQL debugging in PostgreSQL
List pgsql-novice
Tree view 
Michael Holzman <michaelholzman@gmail.com> writes:
> What are the ways of development and debugging of pl/SQL code in PG? Any
> suggestions/hints will be very appreciated.

The standard low-tech way is to sprinkle RAISE NOTICE (or maybe RAISE LOG)
actions throughout your function.  The only real alternative I know about
is EDB's pl/debugger, which I think used to be available standalone but
these days it seems like they only provide it with the pgAdmin GUI.

https://www.pgadmin.org

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Holzman
Date:
Subject: pl/SQL debugging in PostgreSQL
Next
From: Alvaro Herrera
Date:
Subject: Re: pl/SQL debugging in PostgreSQL