Re: logging messages from inside pgPLSQL routine?

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема Re: logging messages from inside pgPLSQL routine?
Дата
Msg-id 20030822012130.GB9496@cc.usu.edu
обсуждение исходный текст
Ответ на logging messages from inside pgPLSQL routine?  (Drew Wilson <amw@speakeasy.net>)
Список 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...


В списке pgsql-sql по дате отправления:

Предыдущее
От: Drew Wilson
Дата:
Сообщение: logging messages from inside pgPLSQL routine?
Следующее
От: MichaelHoeller@t-online.de
Дата:
Сообщение: date calculation