Revert "Put queries into a transaction and rollback after user query"

This reverts commit f670f9aaa9e333b8d66309729bce7a8ff94f3960.

Doesnt work...

1 files changed, 0 insertions, 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);