X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id AA83FD1B4EE for ; Thu, 2 Oct 2003 12:18:14 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 73210-10 for ; Thu, 2 Oct 2003 09:17:28 -0300 (ADT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by svr1.postgresql.org (Postfix) with ESMTP id 7AEDED1B502 for ; Thu, 2 Oct 2003 09:17:24 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1) id 1A52Od-0004fd-0W; Thu, 02 Oct 2003 13:17:27 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 6A52A17963; Thu, 2 Oct 2003 13:17:26 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id B37E7167C1; Thu, 2 Oct 2003 13:17:25 +0100 (BST) From: Richard Huxton To: Popeanga Marian Subject: Re: output Date: Thu, 2 Oct 2003 13:17:24 +0100 User-Agent: KMail/1.5 Cc: pgsql-sql@postgresql.org References: <3F7BE74A.70407@cnlo.ro> <200310021201.06107.dev@archonet.com> <3F7C075C.5050500@cnlo.ro> In-Reply-To: <3F7C075C.5050500@cnlo.ro> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200310021317.24443.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=EMAIL_ATTRIBUTION, IN_REP_TO, RCVD_IN_OSIRUSOFT_COM, REFERENCES, REPLY_WITH_QUOTES, USER_AGENT X-Spam-Level: X-Archive-Number: 200310/29 X-Sequence-Number: 15429 On Thursday 02 October 2003 12:09, Popeanga Marian wrote: > > Inside a plpgsql block . > RAISE NOTICE ''Operation performed!''; > > Now if i don't use psql from where i can read the output ? Ah - I think you need to set CLIENT_MIN_MESSAGES accordingly and then you can check for a non-fatal error code in your result-code. Never done it myself mind. -- Richard Huxton Archonet Ltd