From 62ada070e367e4b0d29f8c6f3a017b94510b1105 Mon Sep 17 00:00:00 2001 From: Benjamin Franzke Date: Sat, 26 Jan 2013 11:03:48 +0100 Subject: Revert "Put queries into a transaction and rollback after user query" This reverts commit f670f9aaa9e333b8d66309729bce7a8ff94f3960. Doesnt work... --- sqlbox/view.php | 6 ------ 1 file changed, 6 deletions(-) diff --git a/sqlbox/view.php b/sqlbox/view.php index f215d7d..47a9de4 100644 --- a/sqlbox/view.php +++ b/sqlbox/view.php @@ -99,18 +99,12 @@ if (isset($data->sqlbox_query)) { print_error('dbconnectionfailed', 'sqlbox'); $table = db_table_from_query($db, $data->sqlbox_query); - $result = @pg_query($db, "BEGIN TRANSACTION;"); - if (!$result) - print_error('dmltransactionexception'); if (strlen($sqlbox->query) > 0) { $table_orig = db_table_from_query($db, $sqlbox->query); if ($table->data != $table_orig->data || $table->head != $table_orig->head) $correct = false; } - $result = @pg_query($db, "ROLLBACK TRANSACTION;"); - if (!$result) - print_error('dmltransactionexception'); pg_close($db); echo html_writer::table($table); -- cgit