A transaction in transaction? Possible?

Поиск
Список
Период
Сортировка
От Andrei Bintintan
Тема A transaction in transaction? Possible?
Дата
Msg-id 014301c4c638$b33af430$0b00a8c0@forge
обсуждение исходный текст
Ответы Re: A transaction in transaction? Possible?  (Michael Fuhr <mike@fuhr.org>)
Re: A transaction in transaction? Possible?  (Theodore Petrosky <tedpet5@yahoo.com>)
Re: A transaction in transaction? Possible?  (Bricklen <bricklen@zyahoo.zcomz>)
Список 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);

 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Kyle
Дата:
Сообщение: Job opportunity
Следующее
От: Andras Kutrovics
Дата:
Сообщение: Re: Simple SQL Question