Is there a way to register a message / error handler within my java code
that will capture any messages issued by a RAISE (debug, log, info etc)
command from within a PL/pgSQL user defined function?



Thanks for any help or direction.



Mike

On Tue, 16 Jan 2007, Votilla, Mike # Pittsburgh wrote:

> Is there a way to register a message / error handler within my java code
> that will capture any messages issued by a RAISE (debug, log, info etc)
> command from within a PL/pgSQL user defined function?
>

There is no specific callback provided, but RAISE output is available via
Statement.getWarnings(). You also need to ensure that
the level you RAISE at is at least that of client_min_messages to ensure
that the server actually sends it to the JDBC driver.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq