Thread: Message / Error Handler
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