From npuleio@rocketmail.com Fri May 8 09:05:17 2009 Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3C867632C17 for ; Fri, 8 May 2009 06:05:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07115-01 for ; Fri, 8 May 2009 06:05:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web33503.mail.mud.yahoo.com (web33503.mail.mud.yahoo.com [68.142.206.152]) by mail.postgresql.org (Postfix) with SMTP id CC026632BF7 for ; Fri, 8 May 2009 06:05:10 -0300 (ADT) Received: (qmail 81448 invoked by uid 60001); 8 May 2009 09:05:09 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=rocketmail.com; s=s1024; t=1241773509; bh=K0iEi6pgnCgxCTe5DnMj1eY84l5J+4PSkqp6kVVpkh8=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=6fuosKv+n6HqupmERHOLW99JmddjMt+lLVzxfP21/yOPbZpLO+GpqQCjWk5CSgBQtwZQ6oBw+nA+inT8zaRu07gvNWa3XaweZcy9DPHhPFr+a6XRRu1qh/Enj2IH6pIPgyToAta47rFS107tVmuuaxD29jVm/Q6wu+dSBvOj2qk= 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:MIME-Version:Content-Type; b=0ypE1fdVrjCpXcqNOGx9W3nWWT1mBLlzUCpfUHt3bhoyh3lBIsER8X5YJfpCv+wuZURJpD0cdkqLYQi6MaAXNCDZ/wuYybtT4yS/eerDuRm82ODyvR2ItGqiE6XRMty8TP0fevqLSQhRRh5BW9bNUlbRMWd1GeF8KihnfzjtV50=; Message-ID: <424047.80512.qm@web33503.mail.mud.yahoo.com> X-YMail-OSG: awWphUwVM1nzO.CZd0v8OV72P15mys1v3Y37EhEH2RJCjq3rGlKz_CQ71BNnXp4Zhrlbe8dLxY1qwY2qXM7m.aO19Ehjp10U0wF7_83FmNDbZH6Xo42WVJO.O8KUmLne_AMWDksREVBY8kw3Fm3aw_WoWSBtggwcxjyWyP1yvVolN.ZjoY_hfoOiy8rwHZaJxIeVkDHAA2C241FCwDvj0tVv2LzASa28w2zg6heCnTB37fpCeJJzkVaagEBU7hqv1u0HhshT7zdRaYAhHi_Am7.gYMjjdhu1xYfRDYHMT7TRTp1vtDJB Received: from [81.208.124.205] by web33503.mail.mud.yahoo.com via HTTP; Fri, 08 May 2009 02:05:08 PDT X-Mailer: YahooMailClassic/5.2.20 YahooMailWebService/0.7.289.10 Date: Fri, 8 May 2009 02:05:08 -0700 (PDT) From: "Luigi N. Puleio" Subject: RAISE NOTICE To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1541576050-1241773508=:80512" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.807 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, SUBJ_ALL_CAPS=1.806 X-Spam-Level: * X-Archive-Number: 200905/20 X-Sequence-Number: 32512 --0-1541576050-1241773508=:80512 Content-Type: text/plain; charset=us-ascii Hello everyone... I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list.. So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... Thanks to all in advance, Ciao Luigi --0-1541576050-1241773508=:80512 Content-Type: text/html; charset=us-ascii
Hello everyone...

I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list..
So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?...

Thanks to all in advance,
Ciao
Luigi

--0-1541576050-1241773508=:80512-- From gherzig@fmed.uba.ar Fri May 8 11:18:32 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 8C018632C4F for ; Fri, 8 May 2009 08:18:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 60169-10 for ; Fri, 8 May 2009 08:18:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1]) by mail.postgresql.org (Postfix) with ESMTP id D81CA632805 for ; Fri, 8 May 2009 08:18:28 -0300 (ADT) Received: from [157.92.155.58] (mailbis [157.92.155.58]) by mail.fmed.uba.ar (Postfix) with ESMTP id 02C0F39BD13; Fri, 8 May 2009 07:57:26 -0300 (ART) Message-ID: <4A0418B7.4020203@fmed.uba.ar> Date: Fri, 08 May 2009 08:34:15 -0300 From: Gerardo Herzig User-Agent: Thunderbird 2.0.0.6 (X11/20070801) MIME-Version: 1.0 To: "Luigi N. Puleio" CC: pgsql-sql@postgresql.org Subject: Re: RAISE NOTICE References: <424047.80512.qm@web33503.mail.mud.yahoo.com> In-Reply-To: <424047.80512.qm@web33503.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200905/25 X-Sequence-Number: 32517 Luigi N. Puleio wrote: > Hello everyone... > > I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list.. > So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... > > Thanks to all in advance, > Ciao > Luigi > > > > That looks like a sql-client (pgAdmin, pgAccess,?) implementation feature, isnt? Gerardo From npuleio@rocketmail.com Fri May 8 11:38:52 2009 Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CAC92633D63 for ; Fri, 8 May 2009 08:38:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30095-10 for ; Fri, 8 May 2009 08:38:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web33505.mail.mud.yahoo.com (web33505.mail.mud.yahoo.com [68.142.206.154]) by mail.postgresql.org (Postfix) with SMTP id 6A230633CE8 for ; Fri, 8 May 2009 08:38:50 -0300 (ADT) Received: (qmail 16783 invoked by uid 60001); 8 May 2009 11:38:48 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=rocketmail.com; s=s1024; t=1241782728; bh=wULhmTwGyqfcczPX/rBgLuk47uDsj1f++j4oDIVvlrY=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=21aNMiUaAk8JzQuQuDMkBWOXS+h8fQtzDJuk0lSGVkLjuPrmII7UZRiqvx9lYzUf55dFXglHZC9LnrUj6rtZrGLz1bbfsYgPx52U8G3ckH0CSOhL9EKMG3tUApdaUOFJSEv5svzwYL8ll3uxEZDnakz2GFc3XojlVYn+DWUe0ZY= 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=Cammlm0S5SI88Ib3D2KiZGlQzqXYCq/E84nyIRy8dpTuPmZFfyWvZC1RSjDGCV1iJJHm7RGeFMsilDxw14/TFTwy5WHiik0bcm1mj1RLMqOTkmqdRgdHfW1yBTcHJp8AQy/52z9U0v2uC+XiC18Od8d6IabKv2pGrwPr1FL7H/Q=; Message-ID: <599839.15720.qm@web33505.mail.mud.yahoo.com> X-YMail-OSG: foz8w.kVM1lzCVhW_kZjHAfw6UJzQU4s75fxP6w_ox_dlt.IGICmODudKq1tMKUD8Qi3wvDIVghUD4pTkt29hjLABE7hMzemIgeV6G8nJXdMVmmRWOAZRXDFXNssrbBIRke3BItV64i93UEt47SRtT.YBBR59EBvjdoCU3XjudZVE.pQYw.OkrtLffRqqprz3RsxF5l9FEnsogIzDKRTHuaqTES_3YAnjEONVhErMbTSMtSQznMG1YCvsh87awuVclb4kPjON8R5zOUX4eKWQ2YLnSjwUdlsiJVcrJVqReXvIv.YovVElz4yRcS.aNBlJbUZ7_J5coIu0hfrs7Ni0vAdGY722Q-- Received: from [81.208.124.205] by web33505.mail.mud.yahoo.com via HTTP; Fri, 08 May 2009 04:38:48 PDT X-Mailer: YahooMailClassic/5.2.20 YahooMailWebService/0.7.289.1 Date: Fri, 8 May 2009 04:38:48 -0700 (PDT) From: "Luigi N. Puleio" Subject: Re: RAISE NOTICE To: Gerardo Herzig Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1989395786-1241782728=:15720" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200905/27 X-Sequence-Number: 32519 --0-1989395786-1241782728=:15720 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable 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 mat= ter is I can't modify the application to manage a possibly notification...o= nly the postgresql's function... That's why I'm asking about a possibility to get a notification from the fu= nction like it's an EXCEPTION... --- On Fri, 5/8/09, Gerardo Herzig wrote: From: Gerardo Herzig Subject: Re: [SQL] RAISE NOTICE To: "Luigi N. Puleio" Cc: pgsql-sql@postgresql.org Date: Friday, May 8, 2009, 11:34 AM Luigi N. Puleio wrote: > Hello everyone... >=20 > I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAIS= E can't be shown on windows with a popup message like the EXCEPTION, indeed= it goes to log messages list.. > So, is there any way to show a popup message with a custom textmessage on= it from a PL/PgSQL function?... >=20 > Thanks to all in advance, > Ciao > Luigi >=20 >=20 >=20 >=A0 =A0 =A0=A0=A0 That looks like a sql-client (pgAdmin, pgAccess,?) implementation feature, isnt? Gerardo --=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-1989395786-1241782728=:15720 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Sort of....the message should come along a st= andalone application too when with an ADO component I do a Post() which cal= ls the function...just the matter is I can't modify the application to mana= ge a possibly notification...only the postgresql's function...
That's wh= y I'm asking about a possibility to get a notification from the function li= ke it's an EXCEPTION...

--- On Fri, 5/8/09, Gerardo Herzig <= ;gherzig@fmed.uba.ar> wrote:

Fro= m: Gerardo Herzig <gherzig@fmed.uba.ar>
Subject: Re: [SQL] RAISE N= OTICE
To: "Luigi N. Puleio" <npuleio@rocketmail.com>
Cc: pgsql-= sql@postgresql.org
Date: Friday, May 8, 2009, 11:34 AM

Luigi N. Puleio wrote:
> Hello everyone...
> > I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE c= an't be shown on windows with a popup message like the EXCEPTION, indeed it= goes to log messages list..
> So, is there any way to show a popup m= essage with a custom textmessage on it from a PL/PgSQL function?...
>=
> Thanks to all in advance,
> Ciao
> Luigi
>
= >
>
>       
That looks like a= sql-client (pgAdmin, pgAccess,?) implementation
feature, isnt?

G= erardo

--
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 --0-1989395786-1241782728=:15720-- From milen@radev.net Fri May 8 11:52:50 2009 Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1EE7D633E7A for ; Fri, 8 May 2009 08:52:50 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32614-01 for ; Fri, 8 May 2009 08:52:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mail.postgresql.org (Postfix) with ESMTP id B601D633D63 for ; Fri, 8 May 2009 08:52:48 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1M2OdA-0001nG-M9 for pgsql-sql@postgresql.org; Fri, 08 May 2009 11:52:44 +0000 Received: from gw-sf.securax.net ([89.253.129.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 08 May 2009 11:52:44 +0000 Received: from milen by gw-sf.securax.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 08 May 2009 11:52:44 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: "Milen A. Radev" Subject: Re: RAISE NOTICE Date: Fri, 08 May 2009 14:52:33 +0300 Lines: 16 Message-ID: References: <599839.15720.qm@web33505.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: gw-sf.securax.net User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) In-Reply-To: <599839.15720.qm@web33505.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200905/28 X-Sequence-Number: 32520 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 npuleio@rocketmail.com Fri May 8 12:01:55 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id BD4FD633D63 for ; Fri, 8 May 2009 09:01:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 69957-02 for ; Fri, 8 May 2009 09:01:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web33501.mail.mud.yahoo.com (web33501.mail.mud.yahoo.com [68.142.206.150]) by mail.postgresql.org (Postfix) with SMTP id 739A0633A56 for ; Fri, 8 May 2009 09:01:50 -0300 (ADT) Received: (qmail 4164 invoked by uid 60001); 8 May 2009 12:01:48 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=rocketmail.com; s=s1024; t=1241784108; bh=VuFVv8/ReG0izSPVkqT0/bfR92kCczB0gY6NNTrtC4o=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=rfZBBqcXpjSzTQ4EpMDl5nbqv6Da55kOE9Pjm1xjK5Gz6JS6wug5nLyraGN0ntVIywa+gMK58zEum8p97fnij3nVM6re02B3Z790XAvg4EGOk4vwNcM8IFCGgTwyoo6ELeiTnVDckvhzdKXuXELzPUfwuTM5KYZzilFBG7vNHs0= 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> X-YMail-OSG: mch2dMoVM1lwESVvUn0QW.fDhRO.xB1zW4tCI8ymRDv8RumjcfOdwPq9f_wysf2cvtCajY7z.LVW_lObH0EWaGZyU3yV8lcXYhLl0tbU5UG037tDbm7nc.hag2reL9_sKyAG1Df109pcYnTFW1DmMuJjTvZRuo0xjHBAuMLdqR0WvOWE3Bpnpgds0NuOVz6saJgreA06EqqdoNpGH5tqMJ4gSVY.8W8BjlkV.4hTOa93taLnHUBBxGcgCK5u3aYp73UOTGgmd5q_H0dnxMGsztwuVt7INedrPCFMINHqarftvZVEfZfou8rZBA-- Received: from [81.208.124.205] by web33501.mail.mud.yahoo.com via HTTP; Fri, 08 May 2009 05:01:45 PDT X-Mailer: YahooMailClassic/5.2.20 YahooMailWebService/0.7.289.10 Date: Fri, 8 May 2009 05:01:45 -0700 (PDT) From: "Luigi N. Puleio" Subject: Re: RAISE NOTICE To: "Milen A. Radev" Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1699786447-1241784105=:4094" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200905/29 X-Sequence-Number: 32521 --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 wrote: From: Milen A. Radev 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
The fact is I have in my postgresql.conf = ; this:

client_min_messages =3D notice

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

that's why I was as= king if there is a way...  maybe I could also have written wrong confi= g for that parameter...

--- On Fri, 5/8/09, Milen A. Radev &l= t;milen@radev.net> wrote:

From: = Milen A. Radev <milen@radev.net>
Subject: Re: [SQL] RAISE NOTICETo: 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 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...
> 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-a= nd-messages.html):

"Whether messages of a particular priority ar= e reported to the client,
written to the server log, or both is controll= ed by the log_min_messages
and client_min_messages configuration variabl= es. See Chapter 18 for more
information."


--
Milen A. Rad= ev


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

=0A=0A= --0-1699786447-1241784105=:4094-- From gherzig@fmed.uba.ar Fri May 8 13:04:32 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 9F169633CE8 for ; Fri, 8 May 2009 10:04:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 83539-09 for ; Fri, 8 May 2009 10:04:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1]) by mail.postgresql.org (Postfix) with ESMTP id 596CF633726 for ; Fri, 8 May 2009 10:04:14 -0300 (ADT) Received: from [157.92.155.58] (mailbis [157.92.155.58]) by mail.fmed.uba.ar (Postfix) with ESMTP id 2ACDF39BDC9; Fri, 8 May 2009 10:03:24 -0300 (ART) Message-ID: <4A043641.7040700@fmed.uba.ar> Date: Fri, 08 May 2009 10:40:17 -0300 From: Gerardo Herzig User-Agent: Thunderbird 2.0.0.6 (X11/20070801) MIME-Version: 1.0 To: "Luigi N. Puleio" CC: pgsql-sql@postgresql.org Subject: Re: RAISE NOTICE References: <599839.15720.qm@web33505.mail.mud.yahoo.com> In-Reply-To: <599839.15720.qm@web33505.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200905/30 X-Sequence-Number: 32522 Luigi N. Puleio wrote: > --- On Fri, 5/8/09, Gerardo Herzig wrote: > > From: Gerardo Herzig > Subject: Re: [SQL] RAISE NOTICE > To: "Luigi N. Puleio" > Cc: pgsql-sql@postgresql.org > Date: Friday, May 8, 2009, 11:34 AM > > Luigi N. Puleio wrote: >> Hello everyone... >> >> I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list.. >> So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... >> >> Thanks to all in advance, >> Ciao >> Luigi >> >> >> >> > That looks like a sql-client (pgAdmin, pgAccess,?) implementation > feature, isnt? > > Gerardo > > 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... > Well, in that case, the ADO component is the client. This is the place to modify de code, to capture the NOTICE. Im shure the ADO (or any other component who actually connect to the database and makes the query) has the ability to react when an EXCEPTION is thrown. My guess is that EXCEPTION's goes trough StandardError, but NOTICE's goes trough StandardOutput, and that could be some idea why your app is not getting notice about NOTICES :) I will wait for some expert dude to respond this, because im going myself into unknown territory. Gerardo From jasen@xnet.co.nz Sun May 10 10:58:41 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 8CFB7632EFF for ; Sun, 10 May 2009 07:58:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 90098-05 for ; Sun, 10 May 2009 07:58:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from titania.wxnz.net (titania.wxnz.net [58.28.4.13]) by mail.postgresql.org (Postfix) with ESMTP id 508CE6328D0 for ; Sun, 10 May 2009 07:58:37 -0300 (ADT) Received: from gonzo (ip-118-90-131-178.xdsl.xnet.co.nz [118.90.131.178]) by titania.wxnz.net (Postfix) with ESMTP id 7550910985CF for ; Sun, 10 May 2009 22:58:34 +1200 (NZST) Received: from news by gonzo with local (Exim 4.69) (envelope-from ) id 1M36j2-0000Qu-Fc for pgsql-sql@postgresql.org; Sun, 10 May 2009 22:57:44 +1200 To: pgsql-sql@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.sql Subject: Re: RAISE NOTICE Date: 10 May 2009 10:57:44 GMT Organization: Dis (not Dat) Organisation Lines: 13 Message-ID: References: <424047.80512.qm@web33503.mail.mud.yahoo.com> NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: reversiblemaps.ath.cx 1241953064 911 127.0.0.1 (10 May 2009 10:57:44 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-2 (Linux) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200905/44 X-Sequence-Number: 32536 On 2009-05-08, Luigi N. Puleio wrote: > > --0-1541576050-1241773508=:80512 > Content-Type: text/plain; charset=us-ascii > > Hello everyone... > > I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list.. > So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... postgres doesn't produce popups (your application does that) To get notification you need to call PQsetNoticeProcessor() to register a callback function. From npuleio@rocketmail.com Mon May 11 06:02:14 2009 Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 96D25633584 for ; Mon, 11 May 2009 03:02:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 71493-01 for ; Mon, 11 May 2009 03:02:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web33503.mail.mud.yahoo.com (web33503.mail.mud.yahoo.com [68.142.206.152]) by mail.postgresql.org (Postfix) with SMTP id 68C81632FAF for ; Mon, 11 May 2009 03:02:10 -0300 (ADT) Received: (qmail 50937 invoked by uid 60001); 11 May 2009 06:02:09 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=rocketmail.com; s=s1024; t=1242021729; bh=qAjzPRbxPJrfFXldv9y/YCbakz7G9bXuOXI34zBdpHg=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=jXwx2RNzxK751RHnVxzyWfxqWHKBPoKysYAxRuRu6rQkW//AbDfEtAdFOjQWHSPNFd3JsliLhjWMogRowpFNnlo9HiaXXEwrsmu6z+NL4HqAMYPz7v32ONloP8Yfl0a6iHdyIavZHBHr65XeeEawIg3Zhy8WNuZQAqt5KuC2/U8= 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=hpb/p+DozVito39Zo/6hUG6JIqMerHr3yiAW3LRIk4Mrh7ZnnwGfFr1m9jAR5O1IY5LxugCXIBiBiEH3NIrQ2sQbILPBTrN4FnQRm5uubOkp7z0TKRgnV7YhSykp9/sT5VB20d8R1T5I6fhRga1OlXM1x62ZKmjMjx4lH+TRcqI=; Message-ID: <301031.49174.qm@web33503.mail.mud.yahoo.com> X-YMail-OSG: ShFEshMVM1n0rqIbUfM5GMxC0zAtlP5.AedBqzVP2VGhLS3L8hHHeu2RAh4GteJlHWi8N5oBaE6J87qEf9I_BdJ4XCZhmC5Y5POBP44fWSkJ9hmQR2AJW8qSJBpjM8CkR41vqvWZYO0MCTD7jQ4SMTEkB.KPvDdPK0QIyNx013OeKcG_EiPHdgOkPWpzP8NAhuTG5s1Hqgr9XNawNPS9sKr4.U8A1zMLD1RyDevp9Ffci9bkhxRaz_c2dzvtOKj8_.hiBJJ4Dqcrsyuus01CBwCzJLOkSQSaQeTDctu4x51D7nvPMRyffczxe7busiH5Mo6trc2VTbhlNlIIl6.OTC7QD68- Received: from [82.52.50.214] by web33503.mail.mud.yahoo.com via HTTP; Sun, 10 May 2009 23:02:08 PDT X-Mailer: YahooMailClassic/5.2.20 YahooMailWebService/0.7.289.10 Date: Sun, 10 May 2009 23:02:08 -0700 (PDT) From: "Luigi N. Puleio" Subject: Re: RAISE NOTICE To: Jasen Betts Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1686780820-1242021728=:49174" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200905/45 X-Sequence-Number: 32537 --0-1686780820-1242021728=:49174 Content-Type: text/plain; charset=us-ascii Hello Jasen, do you know if PQsetNoticeProcessor() is appliable to ADOQuery->Post()? I mean if I have an event where there's ADOQuery->Post(), should I do something like: returnvalue = ADOQuery->Post(); PQsetNoticeProcessor(ADOConnection, PQnoticeProcessor, returnvalue); right?... --- On Sun, 5/10/09, Jasen Betts wrote: From: Jasen Betts Subject: Re: [SQL] RAISE NOTICE To: pgsql-sql@postgresql.org Date: Sunday, May 10, 2009, 10:57 AM On 2009-05-08, Luigi N. Puleio wrote: > > --0-1541576050-1241773508=:80512 > Content-Type: text/plain; charset=us-ascii > > Hello everyone... > > I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list.. > So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... postgres doesn't produce popups (your application does that) To get notification you need to call PQsetNoticeProcessor() to register a callback function. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql --0-1686780820-1242021728=:49174 Content-Type: text/html; charset=us-ascii
Hello Jasen,

do you know if PQsetNoticeProcessor() is appliable to ADOQuery->Post()?

I mean if I have an event where there's ADOQuery->Post(), should I do something like:

returnvalue = ADOQuery->Post();
PQsetNoticeProcessor(ADOConnection, PQnoticeProcessor, returnvalue);
right?...

--- On Sun, 5/10/09, Jasen Betts <jasen@xnet.co.nz> wrote:

From: Jasen Betts <jasen@xnet.co.nz>
Subject: Re: [SQL] RAISE NOTICE
To: pgsql-sql@postgresql.org
Date: Sunday, May 10, 2009, 10:57 AM

On 2009-05-08, Luigi N. Puleio <npuleio@rocketmail.com> wrote:
>
> --0-1541576050-1241773508=:80512
> Content-Type: text/plain; charset=us-ascii
>
> Hello everyone...
>
> I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list..
> So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?...

postgres doesn't produce popups (your application does that)

To get notification you need to call PQsetNoticeProcessor() to register a callback function.

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

--0-1686780820-1242021728=:49174-- From jasen@xnet.co.nz Mon May 11 08:50:33 2009 Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 46D8D632FAF for ; Mon, 11 May 2009 05:50:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96076-06 for ; Mon, 11 May 2009 05:50:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from titania.wxnz.net (titania.wxnz.net [58.28.4.13]) by mail.postgresql.org (Postfix) with ESMTP id E0B8D632AAA for ; Mon, 11 May 2009 05:50:28 -0300 (ADT) Received: from gonzo (ip-118-90-131-178.xdsl.xnet.co.nz [118.90.131.178]) by titania.wxnz.net (Postfix) with ESMTP id 1F3E91098913 for ; Mon, 11 May 2009 20:50:25 +1200 (NZST) Received: from news by gonzo with local (Exim 4.69) (envelope-from ) id 1M3RCW-00005Q-Qs for pgsql-sql@postgresql.org; Mon, 11 May 2009 20:49:32 +1200 To: pgsql-sql@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.sql Subject: Re: RAISE NOTICE Date: 11 May 2009 08:49:32 GMT Organization: Dis (not Dat) Organisation Lines: 44 Message-ID: References: <301031.49174.qm@web33503.mail.mud.yahoo.com> NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: reversiblemaps.ath.cx 1242031772 32330 127.0.0.1 (11 May 2009 08:49:32 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-2 (Linux) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200905/47 X-Sequence-Number: 32539 On 2009-05-11, Luigi N. Puleio wrote: > > --0-1686780820-1242021728=:49174 > Content-Type: text/plain; charset=us-ascii > > Hello Jasen, > > do you know if PQsetNoticeProcessor() is appliable to ADOQuery->Post()? > > I mean if I have an event where there's ADOQuery->Post(), should I do something like: > > returnvalue = ADOQuery->Post(); > PQsetNoticeProcessor(ADOConnection, PQnoticeProcessor, returnvalue); > right?... I suspect that you'll need to get the PQ connection from ADO and use that in the PQsetNoticeProcessor call. this may not be easy. OTOH ADO may already do that if you can fogure out how to enable the feature. > --- On Sun, 5/10/09, Jasen Betts wrote: > > From: Jasen Betts > Subject: Re: [SQL] RAISE NOTICE > To: pgsql-sql@postgresql.org > Date: Sunday, May 10, 2009, 10:57 AM > > On 2009-05-08, Luigi N. Puleio wrote: >> >> --0-1541576050-1241773508=:80512 >> Content-Type: text/plain; charset=us-ascii >> >> Hello everyone... >> >> I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list.. >> So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?... > > postgres doesn't produce popups (your application does that) > > To get notification you need to call PQsetNoticeProcessor() to register a callback function. >