Re: logging messages from inside pgPLSQL routine?

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Drew Wilson <amw(at)speakeasy(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: logging messages from inside pgPLSQL routine?
Date: 2003-08-22 01:21:30
Message-ID: 20030822012130.GB9496@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-08-22 01:40:45 Re: [SQL] "SELECT IN" Still Broken in 7.4b
Previous Message Drew Wilson 2003-08-22 00:21:47 logging messages from inside pgPLSQL routine?