Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 659759F9918 for ; Thu, 4 Oct 2007 00:26:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 52358-08 for ; Thu, 4 Oct 2007 00:26:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from copgpuniv.digitalglobe.com (ew-fw-out.digitalglobe.com [205.166.175.2]) by postgresql.org (Postfix) with ESMTP id F25C99F98FF for ; Thu, 4 Oct 2007 00:26:28 -0300 (ADT) Received: from copgpuniv.digitalglobe.com (localhost.localdomain [127.0.0.1]) by copgpuniv.digitalglobe.com (PGP Universal) with ESMTP id EDCF52A0357; Wed, 3 Oct 2007 21:26:26 -0600 (MDT) Received: from comailgate2.digitalglobe.com ([10.10.42.200]) by copgpuniv.digitalglobe.com (PGP Universal service); Wed, 03 Oct 2007 21:26:26 -0600 X-PGP-Universal: processed; by copgpuniv.digitalglobe.com on Wed, 03 Oct 2007 21:26:26 -0600 Received: from webmail.digitalglobe.com ([10.10.42.65]) by comailgate2.digitalglobe.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 3 Oct 2007 21:26:26 -0600 Received: from [10.9.103.42] ([10.9.103.42]) by webmail.digitalglobe.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 3 Oct 2007 21:26:25 -0600 Message-ID: <47045D54.2070700@digitalglobe.com> Date: Wed, 03 Oct 2007 20:26:12 -0700 From: Greg Williamson User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Ray Madigan Cc: Pgsql-Admin Subject: Re: RAISE NOTICE References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 04 Oct 2007 03:26:26.0155 (UTC) FILETIME=[586C43B0:01C80636] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/17 X-Sequence-Number: 26931 Ray Madigan wrote: > I am trying to debug a trigger using raise notice. When I add this line > > raise notice 'A %', 5; > > I get a syntax erreo at or near "A" > > I am using version 8.1.2 > > Thanks > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > Ray, You don't say what form of quoting you are using, but maybe you could try doubling up those quotes ? raise notice ''A is %'',5; HTH, Greg Williamson Senior DBA GlobeXplorer LLC, a DigitalGlobe company Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. (My corporate masters made me say this.)