From: | "Luigi N(dot) Puleio" <npuleio(at)rocketmail(dot)com> |
---|---|
To: | "Milen A(dot) Radev" <milen(at)radev(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: RAISE NOTICE |
Date: | 2009-05-08 12:01:45 |
Message-ID: | 496803.4094.qm@web33501.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gerardo Herzig | 2009-05-08 13:40:17 | Re: RAISE NOTICE |
Previous Message | Milen A. Radev | 2009-05-08 11:52:33 | Re: RAISE NOTICE |