Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id EB432475D3E
	for <pgsql-sql@postgresql.org>; Fri, 28 Jun 2002 02:54:10 -0400 (EDT)
Mailbox-Line: From nils@naqua.se  Fri Jun 28 02:54:10 2002
Received: from burk.hax.se (burk.Hax.SE [192.176.10.194])
	by postgresql.org (Postfix) with SMTP id A79C247599C
	for <pgsql-sql@postgresql.org>; Fri, 28 Jun 2002 02:54:09 -0400 (EDT)
Received: (qmail 25135 invoked by uid 1002); 28 Jun 2002 06:53:59 -0000
Date: Fri, 28 Jun 2002 08:53:59 +0200
From: =?iso-8859-1?Q?Nils_H=F6glund?= <nils@naqua.se>
To: Joseph Syjuco <joseph@asti.dost.gov.ph>
Cc: postgres <pgsql-sql@postgresql.org>
Subject: Re: transaction in plpgsql
Message-ID: <20020628085358.B18429@Burk.hax.SE>
References: <1025283488.13783.6.camel@Askr>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
User-Agent: Mutt/1.2.5i
In-Reply-To: <1025283488.13783.6.camel@Askr>;
	from joseph@asti.dost.gov.ph on Fri, Jun 28, 2002 at 12:58:06PM
	-0400
X-Spam-Status: No, hits=-5.3 required=5.0 tests=IN_REP_TO,X_NOT_PRESENT
	version=2.30
X-Spam-Level: 
X-Archive-Number: 200206/383
X-Sequence-Number: 8348


> how can i implement transactions inside my plpgsql functions 

I would guess that this is not possible since postgres don't support
nested transactions(?).


-- 
/Nils Höglund, Naqua KB

E-mail:         nils@naqua.se
Web:            http://www.naqua.se/
Home Phone:     +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:        Nya Valsätrav. 26 B
                SE-756 46
                Uppsala, Sweden