Re: RE: [PEAR] MDB transactions

From: Date: Wed, 28 May 2003 08:43:00 +0000
Subject: Re: RE: [PEAR] MDB transactions
References: 1  Groups: php.pear.dev php.pear.general 
Request: Send a blank email to pear-dev+get-16763@lists.php.net to get a copy of this message
Lukas Smith wrote:
From: Jeroen Houben [mailto:jeroen@terena.nl] Sent: Monday, May 26, 2003 1:13 PM
Lukas Smith wrote:
From: Jeroen Houben [mailto:jeroen@terena.nl] Sent: Monday, May 12, 2003 3:09 PM
I have a problem using transaction with the latest version of MDB
and
postgresql 7.2 $db->autoCommit(false); var_dump($db->auto_commit); // this prints bool(false) // some queries ... $db->commit(); That fails giving me this message MDB Error: unknown error Commit: transaction changes are being auto commited
Ok I hope I solved the issue. Your hint with in_transaction not being set was correct. Try and see if things work now. I don't have time to check myself atm :-/ I replaced the stable pgsql.php and common.php with the CVS versions and now I get other errors not related to the replace method.
Notice: Undefined index: Coordinators in /usr/local/share/php/pear/MDB/pgsql.php on line 1267 Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /usr/local/share/php/pear/MDB/pgsql.php on line 799 Warning: pg_freeresult(): supplied argument is not a valid PostgreSQL result resource in /usr/local/share/php/pear/MDB/pgsql.php on line 823 HTH Jeroen

« previous php.pear.dev (#16763) next »