summaryrefslogtreecommitdiff
path: root/contrib/rtree_gist/bench/bench.pl
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/rtree_gist/bench/bench.pl')
-rwxr-xr-xcontrib/rtree_gist/bench/bench.pl14
1 files changed, 14 insertions, 0 deletions
diff --git a/contrib/rtree_gist/bench/bench.pl b/contrib/rtree_gist/bench/bench.pl
index e6bc1332cf..e42ec9c63a 100755
--- a/contrib/rtree_gist/bench/bench.pl
+++ b/contrib/rtree_gist/bench/bench.pl
@@ -25,6 +25,20 @@ EOT
$opt{d} ||= 'TEST';
my $dbi=DBI->connect('DBI:Pg:dbname='.$opt{d}) || die "Couldn't connect DB: $opt{d} !\n";
+my $setsql = qq{
+ SET search_path = public;
+};
+
+my $sth = $dbi->prepare($setsql);
+$sth->execute();
+
+my $setsql2 = qq{
+ SET autocommit TO 'on';
+};
+
+my $sth2 = $dbi->prepare($setsql2);
+$sth2->execute();
+
my $sql;
my $notice;
my $sss = '(3000,3000,2990,2990)';