Re: RAISE NOTICE

Поиск
Список
Период
Сортировка
От Luigi N. Puleio
Тема Re: RAISE NOTICE
Дата
Msg-id 496803.4094.qm@web33501.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на RAISE NOTICE  ("Luigi N. Puleio" <npuleio@rocketmail.com>)
Список 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@radev.net> wrote:

From: Milen A. Radev <milen@radev.net>
Subject: Re: [SQL] RAISE NOTICE
To: pgsql-sql@postgresql.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


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

В списке pgsql-sql по дате отправления: