Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.8.6
Bug #3857 MDB2_Tools_Manager, PostgreSQL and transactions
Submitted: 2005-03-17 04:43 UTC
From: justinh at superglobals dot com Assigned:
Status: No Feedback Package: MDB2_Schema
PHP Version: 5.0.3 OS:
Roadmaps: (Not assigned)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 8 + 4 = ?

 
 [2005-03-17 04:43 UTC] justinh at superglobals dot com
Description: ------------ In PostgreSQL, if an error occurs during a transaction, the transaction moves to an abort state and any subsequent queries during that transaction are ignored. MDB2_Tools_Manager executes queries and uses returned errors to determine behavior, thus causing PostgreSQL to enter an abort state, which negates any subsequent queries. As a work-around, before calling MDB2_Tools_Manager::updateDatabase(), you can set MDB2::$supported['transactions'] to FALSE, preventing the transaction problem from occuring.

Comments

 [2005-03-17 15:29 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2005-04-01 13:36 UTC] smith at backendmedia dot com
It seems pgsql (and newer oracle releases) are among the few that support DDL statements in transactions. So it seems I should drop transactions around DDL statements.
 [2005-04-09 11:54 UTC] smith at backendmedia dot com
it seems like DB2 (although unsupported by MDB2) also supports transactional ddl statements, so the best course of action is to add a supports entry for this in MDB2 and check for this in the Manager. also instead of attempting to overwrite by creating and checking for errors I will try to first check and create/truncate on demand.
 [2005-04-16 22:24 UTC] smith at backendmedia dot com
could you check current cvs?
 [2005-06-03 07:52 UTC] smith at backendmedia dot com
any chances to get this tested?
 [2005-06-17 15:12 UTC] justinh at superglobals dot com
Sorry I haven't responded to this yet. The email address in the bug is incorrect, so I'm not getting emails when this bug changes. I have not had a chance to check this out against the latest builds of MDB2. I'll check into this weekend.