catching errors in function - Mailing list pgsql-sql

From padmanabha konkodi
Subject catching errors in function
Date
Msg-id 20051006065546.15349.qmail@webmail29.rediffmail.com
Whole thread Raw
Responses Re: catching errors in function  ("Eugene E." <sad@bankir.ru>)
Re: catching errors in function  (John DeSoi <desoi@pgedit.com>)
List pgsql-sql
<p>   <br /> hello sql developers,<br /><br /> i have written function in which while executing it may throw error.<br
/>if the error thrown i want rollback the transaction if not i want commit.<br /><br /> how can i achive this task.<br
/><br/> how can catch exception thrown in the function<br /><br /> plz help me<br /><br /><br /> regards<br />
konkodi<br/><br /><br /><a
href="http://adworks.rediff.com/cgi-bin/AdWorks/sigclick.cgi/www.rediff.com/signature-home.htm/1507191490@Middle5?PARTNER=3"><img
border="0"hspace="0"
src="http://adworks.rediff.com/cgi-bin/AdWorks/sigimpress.cgi/www.rediff.com/signature-home.htm/1963059423@Middle5?OAS_query=null&PARTNER=3"
vspace="0"/></a> 

pgsql-sql by date:

Previous
From: "Stewart Ben (RBAU/EQS4) *"
Date:
Subject: Scripting GRANT on functions
Next
From: "Eugene E."
Date:
Subject: Re: catching errors in function