catching errors in function

From: "padmanabha konkodi" <konkodi221(at)rediffmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: catching errors in function
Date: 2005-10-06 06:55:46
Message-ID: 20051006065546.15349.qmail@webmail29.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

 
hello sql developers,

i have written function in which while executing it may throw error.
if the error thrown i want rollback the transaction if not i want commit.

how can i achive this task.

how can catch exception thrown in the function

plz help me

regards
konkodi

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Eugene E. 2005-10-06 07:11:51 Re: catching errors in function
Previous Message Stewart Ben (RBAU/EQS4) * 2005-10-06 05:27:25 Scripting GRANT on functions