Re: pl/SQL debugging in PostgreSQL

Tom Lane <[email protected]>
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <[email protected]>
Michael Holzman <[email protected]> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.