How about using a try catch block?
isn't that more efficient that eval?
~Jas
On 3/15/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Jasbinder Singh Bali" <jsbali(at)gmail(dot)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
>