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