X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 5EA9DD9CD7
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  6 Oct 2005 04:01:18 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 93527-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  6 Oct 2005 07:01:07 +0000 (GMT)
Received: from rediffmail.com (unknown [203.199.83.39])
	by svr1.postgresql.org (Postfix) with SMTP id 92536D8833
	for <pgsql-sql@postgresql.org>; Thu,  6 Oct 2005 04:01:06 -0300 (ADT)
Received: (qmail 15351 invoked by uid 510); 6 Oct 2005 06:55:46 -0000
Date: 6 Oct 2005 06:55:46 -0000
Message-ID: <20051006065546.15349.qmail@webmail29.rediffmail.com>
Received: from unknown (61.11.63.192) by rediffmail.com via HTTP;
	06 oct 2005 06:55:46 -0000
MIME-Version: 1.0
From: "padmanabha konkodi" <konkodi221@rediffmail.com>
Reply-To: "padmanabha konkodi" <konkodi221@rediffmail.com>
To: pgsql-sql@postgresql.org
Subject: catching errors in  function 
Content-type: multipart/alternative;
	boundary="Next_1128581746---0-203.199.83.39-15296"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=2.956 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374,
	FROM_ENDS_IN_NUMS=0.516, HTML_50_60=0.095, HTML_IMAGE_ONLY_08=1.97,
	HTML_MESSAGE=0.001, MSGID_FROM_MTA_HEADER=0]
X-Spam-Level: **
X-Archive-Number: 200510/47
X-Sequence-Number: 22900

 This is a multipart mime message


--Next_1128581746---0-203.199.83.39-15296
Content-type: text/plain;
	charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

 =A0=0Ahello sql developers,=0A=0Ai have written function in which while ex=
ecuting it may throw error.=0Aif the error thrown i want rollback the trans=
action if not i want commit.=0A=0Ahow can i achive this task.=0A=0Ahow can =
catch exception thrown in the function=0A=0Aplz help me=0A=0A=0Aregards=0Ak=
onkodi=0A
--Next_1128581746---0-203.199.83.39-15296
Content-type: text/html;
	charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<P>=0A&nbsp; <BR>=0Ahello sql developers,<BR>=0A<BR>=0Ai have written funct=
ion in which while executing it may throw error.<BR>=0Aif the error thrown =
i want rollback the transaction if not i want commit.<BR>=0A<BR>=0Ahow can =
i achive this task.<BR>=0A<BR>=0Ahow can catch exception thrown in the func=
tion<BR>=0A<BR>=0Aplz help me<BR>=0A<BR>=0A<BR>=0Aregards<BR>=0Akonkodi<BR>=
=0A=0A</P>=0A<br><br>=0A<a href=3D"http://adworks.rediff.com/cgi-bin/AdWork=
s/sigclick.cgi/www.rediff.com/signature-home.htm/1507191490@Middle5?PARTNER=
=3D3"><IMG SRC=3D"http://adworks.rediff.com/cgi-bin/AdWorks/sigimpress.cgi/=
www.rediff.com/signature-home.htm/1963059423@Middle5?OAS_query=3Dnull&PARTN=
ER=3D3" BORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A
--Next_1128581746---0-203.199.83.39-15296--