X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D142F3A3C4D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Nov 2004 15:25:18 +0000 (GMT)
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 54526-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Nov 2004 15:25:12 +0000 (GMT)
Received: from web41007.mail.yahoo.com (web41007.mail.yahoo.com [66.218.93.6])
	by svr1.postgresql.org (Postfix) with SMTP id 8AC803A1EC4
	for <pgsql-sql@postgresql.org>; Tue,  9 Nov 2004 15:25:14 +0000 (GMT)
Received: (qmail 51570 invoked by uid 60001); 9 Nov 2004 15:25:03 -0000
Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	b=gf+KXB5nSrLFSkvcKadzEQ0MkSYCUITvJYMWFW4QyGnOpx2PdJ7KeZWQUHp+gKGT20JrJi6MHxp+ogCGKylWgIsBTYIGRUeX2VFgSxsmaXZThUqw7f/Y8Hx4a4c5fat42AhWFZIHPUtVImEEnV0hH3cHTJpnegSA5A4/HV111QQ=
	;
Message-ID: <20041109152458.51487.qmail@web41007.mail.yahoo.com>
Received: from [151.204.106.98] by web41007.mail.yahoo.com via HTTP;
	Tue, 09 Nov 2004 07:24:57 PST
Date: Tue, 9 Nov 2004 07:24:57 -0800 (PST)
From: Theodore Petrosky <tedpet5@yahoo.com>
Subject: Re: A transaction in transaction? Possible?
To: Andrei Bintintan <klodoma@ar-sd.net>, pgsql-sql@postgresql.org
In-Reply-To: <014301c4c638$b33af430$0b00a8c0@forge>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200411/84
X-Sequence-Number: 19403

I thought nested transactions are available in the new
release (8) coming up.

Ted

--- Andrei Bintintan <klodoma@ar-sd.net> wrote:

> Is it possible to have another transatction in a
> transaction??? In the following example the last
> ROLLBACK is totally ignored(transaction1). 
> 
> //connect to database
> $database = dbConnect($dbhost, $dbuser, $dbpass,
> $dbname);
> dbExec($database, "BEGIN"); //transaction1
> 
> //*
>         dbExec($database, "BEGIN");//transaction2
>             $sql = "UPDATE orders SET
> technikernotiz='51' WHERE id=16143";
>             dbExec($database, $sql);
>         dbExec($database, "COMMIT");//transaction2
> /**/
> 
>     $sql = "UPDATE orders SET
> reklamationsdetail='51' WHERE id=16143";
>     dbExec($database, $sql);
> dbExec($database, "ROLLBACK");//transaction1
> 
> dbClose($database);
> 
> 
> 


		
__________________________________ 
Do you Yahoo!? 
Check out the new Yahoo! Front Page. 
www.yahoo.com