Re: pl/pgSQL development environment

"Wm.A.Stafford" <stafford@marine.rutgers.edu> writes:
> ... Using both  psql and pgADMINIII I was able to load and execute this and
> see 2 as the output but I did not
> see the output of the RAISE statement.  The RAISE output was not in the
> log file either.
> Where does it go and can it be redirected to stdout?

In addition to the other comments: client_min_messages can be adjusted
if you want to get DEBUG-level messages on the client side.  (I'm not
sure how well that works in pgAdmin, but it definitely works in psql.)
Realize though that you'll get chatter from built-in DEBUG output too,
whether you are sending it to the log or the client.  It might be better
to use a higher message level for temporary debugging messages in
plpgsql functions.  I tend to use NOTICE myself.

> Since pl/pgSQL does not have packages, what is the usual way of managing
> groups of related functions and procedures.

About all you can do at the moment is put them all into a schema.
There has been some talk of creating a "module" facility in future
PG releases, but nothing's happened beyond talk, yet.

            regards, tom lane