Re: RAISE NOTICE

The fact is I have in my postgresql.conf  this:

client_min_messages = notice

but if I call the function which has RAISE NOTICE it doesn't return a notice to the clienti...indeed I see it in the logfile on server status...

that's why I was asking if there is a way...  maybe I could also have written wrong config for that parameter...

--- On Fri, 5/8/09, Milen A. Radev <milen(at)radev(dot)net> wrote:

From: Milen A. Radev <milen(at)radev(dot)net>
Subject: Re: [SQL] RAISE NOTICE
To: pgsql-sql(at)postgresql(dot)org
Date: Friday, May 8, 2009, 11:52 AM

Luigi N. Puleio написа:
> Sort of....the message should come along a standalone application too when with an ADO component I do a Post() which calls the function...just the matter is I can't modify the application to manage a possibly notification...only the postgresql's function...
> That's why I'm asking about a possibility to get a notification from the function like it's an EXCEPTION...
[...]

I believe the fine manual is clear about this
(http://www.postgresql.org/docs/current/static/plpgsql-errors-and-messages.html):

"Whether messages of a particular priority are reported to the client,
written to the server log, or both is controlled by the log_min_messages
and client_min_messages configuration variables. See Chapter 18 for more
information."

--
Milen A. Radev