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 E00B5D1BB49 for ; Thu, 21 Aug 2003 21:52:14 -0300 (ADT) 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 12866-09 for ; Thu, 21 Aug 2003 21:51:47 -0300 (ADT) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.103]) by svr1.postgresql.org (Postfix) with ESMTP id 73AF0D1BB7D for ; Thu, 21 Aug 2003 21:51:28 -0300 (ADT) Received: from roberto by brasileiro.net with local (Exim 3.36 #1 (Debian)) id 19q0cN-0002U3-00; Thu, 21 Aug 2003 19:21:31 -0600 Date: Thu, 21 Aug 2003 19:21:30 -0600 From: Roberto Mello To: Drew Wilson Cc: pgsql-sql@postgresql.org Subject: Re: logging messages from inside pgPLSQL routine? Message-ID: <20030822012130.GB9496@cc.usu.edu> References: <200308181611.27937.josh@agliodbs.com> <9E11790C-D436-11D7-A9F2-000393D3E482@speakeasy.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <9E11790C-D436-11D7-A9F2-000393D3E482@speakeasy.net> X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/264 X-Sequence-Number: 14880 On Thu, Aug 21, 2003 at 05:21:47PM -0700, Drew Wilson wrote: > I'mm trying to debug something inside my PLSQL routine. How do I print > out error messages from inside my function? RAISE NOTICE ''Foobar is %'', foobar; Where "foobar" is a variable. The documentation mentions this in several places and examples. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + Compiling...Linking...Dialing Copyright Lawyer...