Thread: Exceptions in PL/Perl?

How does one raise an exception from a PL/Perl function? Specifically,
this is a trigger function. Is it as simple as "die <msg>"?

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 david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

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