DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rocketmail.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type;
	b=UeGiDMARhiELE9whkARhfpTcjrX6Gy8w1E5ZCZRncpi0p+XUzFVipavuly16lsAnd90xN2jDNyRXSMCIq7y9z70WSMyGZCzxVXXaBNzrCVAtTfIHHOpBEB0QeWhtvfwmpNh6kVxLodNELW1JUdiicBjlcFH46SZCnG4wuJfna90=;
Message-ID: <496803.4094.qm@web33501.mail.mud.yahoo.com>
Date: Fri, 8 May 2009 05:01:45 -0700 (PDT)
From: "Luigi N. Puleio" <npuleio@rocketmail.com>
Subject: Re: RAISE NOTICE
To: "Milen A. Radev" <milen@radev.net>
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1699786447-1241784105=:4094"


--0-1699786447-1241784105=:4094
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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

client_min_messages =3D notice

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

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

--- 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 =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0:
> Sort of....the message should come along a standalone application too whe=
n with an ADO component I do a Post() which calls the function...just the m=
atter 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."


--=20
Milen A. Radev


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
=0A=0A=0A      
--0-1699786447-1241784105=:4094
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">The fact is I have in my postgresql.conf&nbsp=
; this:<br><br>client_min_messages =3D notice<br><br>but if I call the func=
tion which has RAISE NOTICE it doesn't return a notice to the clienti...ind=
eed I see it in the logfile on server status... <br><br>that's why I was as=
king if there is a way...&nbsp; maybe I could also have written wrong confi=
g for that parameter... <br><br>--- On <b>Fri, 5/8/09, Milen A. Radev <i>&l=
t;milen@radev.net&gt;</i></b> wrote:<br><blockquote style=3D"border-left: 2=
px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: =
Milen A. Radev &lt;milen@radev.net&gt;<br>Subject: Re: [SQL] RAISE NOTICE<b=
r>To: pgsql-sql@postgresql.org<br>Date: Friday, May 8, 2009, 11:52 AM<br><b=
r><div class=3D"plainMail">Luigi N. Puleio =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=
=D0=B0:<br>&gt; Sort of....the message should come along a standalone appli=
cation too when with an ADO
 component I do a Post() which calls the function...just the matter is I ca=
n't modify the application to manage a possibly notification...only the pos=
tgresql's function...<br>&gt; That's why I'm asking about a possibility to =
get a notification from the function like it's an EXCEPTION...<br>[...]<br>=
<br>I believe the fine manual is clear about this<br>(<a href=3D"http://www=
.postgresql.org/docs/current/static/plpgsql-errors-and-messages.html" targe=
t=3D"_blank">http://www.postgresql.org/docs/current/static/plpgsql-errors-a=
nd-messages.html</a>):<br><br>"Whether messages of a particular priority ar=
e reported to the client,<br>written to the server log, or both is controll=
ed by the log_min_messages<br>and client_min_messages configuration variabl=
es. See Chapter 18 for more<br>information."<br><br><br>-- <br>Milen A. Rad=
ev<br><br><br>-- <br>Sent via pgsql-sql mailing list (<a ymailto=3D"mailto:=
pgsql-sql@postgresql.org"
 href=3D"/mc/compose?to=3Dpgsql-sql@postgresql.org">pgsql-sql@postgresql.or=
g</a>)<br>To make changes to your subscription:<br><a href=3D"http://www.po=
stgresql.org/mailpref/pgsql-sql" target=3D"_blank">http://www.postgresql.or=
g/mailpref/pgsql-sql</a><br></div></blockquote></td></tr></table><br>=0A=0A=
      
--0-1699786447-1241784105=:4094--