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

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!

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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/s...-database.html

--
Michael Fuhr

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