summaryrefslogtreecommitdiff
path: root/sqlbox/view.php
diff options
context:
space:
mode:
authorBenjamin Franzke <benjaminfranzke@googlemail.com>2013-01-26 11:03:48 +0100
committerBenjamin Franzke <benjaminfranzke@googlemail.com>2013-01-26 11:03:48 +0100
commit62ada070e367e4b0d29f8c6f3a017b94510b1105 (patch)
tree6c90d3a9d123b842f7c3faeac0594734bbb4a401 /sqlbox/view.php
parentea3050d1734c3d64f5ff7dd1659f48463dab9793 (diff)
downloadsqltutor-plugin-62ada070e367e4b0d29f8c6f3a017b94510b1105.tar.gz
sqltutor-plugin-62ada070e367e4b0d29f8c6f3a017b94510b1105.tar.bz2
sqltutor-plugin-62ada070e367e4b0d29f8c6f3a017b94510b1105.zip
Revert "Put queries into a transaction and rollback after user query"
This reverts commit f670f9aaa9e333b8d66309729bce7a8ff94f3960. Doesnt work...
Diffstat (limited to 'sqlbox/view.php')
-rw-r--r--sqlbox/view.php6
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);