Re: exception handling in plperlu - Mailing list pgsql-general

From Jasbinder Singh Bali
Subject Re: exception handling in plperlu
Date
Msg-id a47902760703151906t597d8a1cy1087e2058803bff5@mail.gmail.com
Whole thread Raw
In response to Re: exception handling in plperlu  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: exception handling in plperlu  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
How about using a try catch block?
isn't that more efficient that eval?
 
~Jas

 
On 3/15/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Jasbinder Singh Bali" <jsbali@gmail.com> writes:
> Actually, if I rephrase my requirement, I need to catch an exception at any
> point ,where ever it is raised, in the perl code.
> E.g during an insert, there is a foreign key contraint violation, then i
> need to catch this specific error and do something with it.

Since PG 8.0, you should be able to trap exceptions with eval{}, same as
you would do in any Perl code.

                       regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: exception handling in plperlu
Next
From: "Michael Su"
Date:
Subject: Re: About the new day-time saving rule