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
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">The fact is I have in my
postgresql.conf this:<br /><br />client_min_messages = notice<br /><br />but if I call the function which has RAISE
NOTICEit doesn't return a notice to the clienti...indeed I see it in the logfile on server status... <br /><br />that's
whyI was asking if there is a way...  maybe I could also have written wrong config for that parameter... <br /><br
/>---On <b>Fri, 5/8/09, Milen A. Radev <i><milen@radev.net></i></b> wrote:<br /><blockquote style="border-left:
2pxsolid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br />From: Milen A. Radev <milen@radev.net><br
/>Subject:Re: [SQL] RAISE NOTICE<br />To: pgsql-sql@postgresql.org<br />Date: Friday, May 8, 2009, 11:52 AM<br /><br
/><divclass="plainMail">Luigi N. Puleio написа:<br />> Sort of....the message should come along a standalone
applicationtoo when with an ADO component I do a Post() which calls the function...just the matter is I can't modify
theapplication to manage a possibly notification...only the postgresql's function...<br />> That's why I'm asking
abouta possibility to get a notification from the function like it's an EXCEPTION...<br />[...]<br /><br />I believe
thefine manual is clear about this<br />(<a
href="http://www.postgresql.org/docs/current/static/plpgsql-errors-and-messages.html"
target="_blank">http://www.postgresql.org/docs/current/static/plpgsql-errors-and-messages.html</a>):<br/><br />"Whether
messagesof a particular priority are reported to the client,<br />written to the server log, or both is controlled by
thelog_min_messages<br />and client_min_messages configuration variables. See Chapter 18 for more<br />information."<br
/><br/><br />-- <br />Milen A. Radev<br /><br /><br />-- <br />Sent via pgsql-sql mailing list (<a
href="/mc/compose?to=pgsql-sql@postgresql.org"
ymailto="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br/>To make changes to your subscription:<br
/><ahref="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></div></blockquote></td></tr></table><br /> 

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

Предыдущее
От: "Milen A. Radev"
Дата:
Сообщение: Re: RAISE NOTICE
Следующее
От: Gerardo Herzig
Дата:
Сообщение: Re: RAISE NOTICE