Re: RAISE NOTICE

<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 />