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