[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pear-general
Subject:    [PEAR] DB_DataObject and transactions
From:       "=?koi8-r?B?5NjR3sXOy88g4S73Lg==?=" <djachenko () ubrr ! ru>
Date:       2002-10-31 9:23:22
[Download RAW message or body]


Hi,

is any way to use several DataObjects within one transaction? As I understand each \
instance of DataObject creates own connection and so new trancaton begins. PostgreSQL \
doesn't support nested transactions, so I have such situation:

$do1 = new DO_Type1;
$do1->query('begin work');
... loop ...
$do1->insert();
... end loop ...
$do2 = new DO_Type2;
$do2->insert();
$do1->query('rollback');

and $do2 insert operation doesn't rollback.

May be I do something wrong? Please help.

Andrew Djachenko



[prev in list] [next in list] [prev in thread] [next in thread]