Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C862F9F9A64 for ; Thu, 4 Oct 2007 00:00:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 02560-10 for ; Thu, 4 Oct 2007 00:00:28 -0300 (ADT) X-Greylist: delayed 00:35:03.422219 by SQLgrey-1.7.5 Received: from n126.sc0.he.tucows.com (smtpout1114.sc0.he.tucows.com [64.97.144.114]) by postgresql.org (Postfix) with ESMTP id A48669F9A11 for ; Thu, 4 Oct 2007 00:00:27 -0300 (ADT) Received: from dreamland (74.94.66.41) by n126.sc0.he.tucows.com (7.2.069.1) (authenticated as ray@madigans.org) id 47030515000382D8 for pgsql-admin@postgresql.org; Thu, 4 Oct 2007 02:25:22 +0000 From: "Ray Madigan" To: "Pgsql-Admin" Subject: RAISE NOTICE Date: Wed, 3 Oct 2007 19:25:13 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896 Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/16 X-Sequence-Number: 26930 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