Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.8.5

Bug #3857 MDB2_Tools_Manager, PostgreSQL and transactions
Submitted: 2005-03-16 23:43 UTC Modified: 2005-10-05 08:03 UTC
From: justinh at superglobals dot com Assigned:
Status: No Feedback Package: MDB2_Schema
PHP Version: 5.0.3 OS:
Roadmaps: (Not assigned)    
Subscription  


 [2005-03-16 23: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 10:29 UTC] justinh
Fixed incorrect summary.
 [2005-04-01 07: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 06: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 17:24 UTC] smith at backendmedia dot com
could you check current cvs?
 [2005-06-03 02:52 UTC] smith at backendmedia dot com
any chances to get this tested?
 [2005-06-17 10: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.