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