"Jasbinder Singh Bali" <jsbali@xxxxxxxxx> 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