From: Theodore Petrosky <tedpet5@yahoo.com>
To: Andrei Bintintan <klodoma@ar-sd.net>
To: pgsql-sql@postgresql.org
Subject: Re: A transaction in transaction? Possible?
Date: Tue, 9 Nov 2004 07:24:57 -0800 (PST)
Message-ID: <20041109152458.51487.qmail@web41007.mail.yahoo.com> (raw)
In-Reply-To: <014301c4c638$b33af430$0b00a8c0@forge>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tedpet5@yahoo.com, klodoma@ar-sd.net
Subject: Re: A transaction in transaction? Possible?
In-Reply-To: <20041109152458.51487.qmail@web41007.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox