| 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) | ||
[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-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.