A transaction in transaction? Possible?

From: "Andrei Bintintan" <klodoma(at)ar-sd(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: A transaction in transaction? Possible?
Date: 2004-11-09 08:47:06
Message-ID: 014301c4c638$b33af430$0b00a8c0@forge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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);

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andras Kutrovics 2004-11-09 09:16:22 Re: Simple SQL Question
Previous Message Kyle 2004-11-08 23:29:08 Job opportunity