Since I'm executing this from a PgSQL function, can be SQLWarning eventually called from inside the function?....
and to use it let me guess I have to install something related to java like JRE 1.5.0?...
Thanks Ciao, Luigi
--- On Thu, 5/7/09, Kris Jurka <books@ejurka.com> wrote:
From: Kris Jurka <books@ejurka.com> Subject: Re: [GENERAL] A question about RAISE NOTICE To: "Craig Ringer" <craig@postnewspapers.com.au> Cc: "Luigi N. Puleio" <npuleio@rocketmail.com>, pgsql-general@postgresql.org Date: Thursday, May 7, 2009, 11:51 PM
On Thu, 7 May 2009, Craig Ringer wrote:
> Most programs will not be aware of notice messages. Unlike error > messages there's no provision for them in standard JDBC/ODBC/etc APIs, > and you have to specifically ask the client driver for them. Unless your > app is aware of PostgreSQL specifically, it won't be doing that.
The JDBC API has a SQLWarning that we map notice messages to and are understood by client tools.