diff options
author | Andrew Dolgov <[email protected]> | 2013-08-02 16:20:39 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2013-08-02 16:20:39 +0400 |
commit | 38f439708cd78b224978c3d3d9cd85d40a9f9c04 (patch) | |
tree | c99ec40d3358f2bc9d7dc5e1426793ec659a4ad1 /classes/db/pgsql.php | |
parent | edba269b6f3f2ed594c75f5ad9a6b3ecfeb3121f (diff) |
rollback current transaction before trying to report SQL query errors, properly save database error messages when logging query errors
Diffstat (limited to 'classes/db/pgsql.php')
-rw-r--r-- | classes/db/pgsql.php | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/classes/db/pgsql.php b/classes/db/pgsql.php index 4d860790b..ba37f83a6 100644 --- a/classes/db/pgsql.php +++ b/classes/db/pgsql.php @@ -35,11 +35,14 @@ class Db_Pgsql implements IDb { } function query($query, $die_on_error = true) { - $result = pg_query($query); + $result = @pg_query($this->link, $query); if (!$result) { + $error = @pg_last_error($this->link); + + @pg_query($this->link, "ROLLBACK"); $query = htmlspecialchars($query); // just in case - user_error("Query $query failed: " . ($this->link ? pg_last_error($this->link) : "No connection"), + user_error("Query $query failed: " . ($this->link ? $error : "No connection"), $die_on_error ? E_USER_ERROR : E_USER_WARNING); } return $result; |