[GENERAL] Exceptions in PL/Perl?

2005-08-11 Thread Jeff Boes
How does one raise an exception from a PL/Perl function? Specifically,
this is a trigger function. Is it as simple as die msg?

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [GENERAL] Exceptions in PL/Perl?

2005-08-11 Thread David Fetter
On Thu, Aug 11, 2005 at 10:15:11AM -0400, Jeff Boes wrote:
 How does one raise an exception from a PL/Perl function?
 Specifically, this is a trigger function. Is it as simple as die
 msg?

elog(ERROR, $errmsg)

works.

Cheers,
D
-- 
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [GENERAL] Exceptions in PL/Perl?

2005-08-11 Thread Michael Fuhr
On Thu, Aug 11, 2005 at 10:15:11AM -0400, Jeff Boes wrote:
 How does one raise an exception from a PL/Perl function? Specifically,
 this is a trigger function. Is it as simple as die msg?

Use elog:

http://www.postgresql.org/docs/8.0/static/plperl-database.html

-- 
Michael Fuhr

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings