summaryrefslogtreecommitdiff
path: root/contrib/adddepend
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2003-05-14 03:26:03 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2003-05-14 03:26:03 +0000
commitf85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c (patch)
tree149a8221767ed2e9c63adc58cc88c4d8faca5381 /contrib/adddepend
parentd9b679c13a820eb7b464a1eeb1f177c3fea13ece (diff)
downloadpostgresql-f85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c.tar.gz
Backend support for autocommit removed, per recent discussions. The
only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq.
Diffstat (limited to 'contrib/adddepend')
-rwxr-xr-xcontrib/adddepend/adddepend11
1 files changed, 2 insertions, 9 deletions
diff --git a/contrib/adddepend/adddepend b/contrib/adddepend/adddepend
index 5d743ced6e..4fa8bc5d38 100755
--- a/contrib/adddepend/adddepend
+++ b/contrib/adddepend/adddepend
@@ -1,5 +1,5 @@
#!/usr/bin/perl
-# $Id: adddepend,v 1.3 2002/12/02 00:28:29 tgl Exp $
+# $Id: adddepend,v 1.4 2003/05/14 03:25:55 tgl Exp $
# Project exists to assist PostgreSQL users with their structural upgrade
# from 7.2 (or prior) to 7.3 (possibly later). Must be run against a 7.3
@@ -125,20 +125,13 @@ my $dbh = DBI->connect($dsn, $dbuser, $dbpass);
# We want to control commits
$dbh->{'AutoCommit'} = 0;
-# turn on autocommit
+# control where things get created
my $sql = qq{
SET search_path = public;
};
my $sth = $dbh->prepare($sql);
$sth->execute();
-# turn on autocommit
-my $sql2 = qq{
- SET autocommit TO 'on';
-};
-my $sth2 = $dbh->prepare($sql2);
-$sth2->execute();
-
END {
$dbh->disconnect() if $dbh;
}