4 files changed, 2 insertions, 20 deletions
diff --git a/contrib/dbmirror/AddTrigger.sql b/contrib/dbmirror/AddTrigger.sql
index de07c3ae00..97150d3aa7 100644
--- a/contrib/dbmirror/AddTrigger.sql
+++ b/contrib/dbmirror/AddTrigger.sql
@@ -1,8 +1,6 @@
 -- Adjust this setting to control where the objects get created.
 SET search_path = public;
 
-SET autocommit TO 'on';
-
 CREATE TRIGGER "MyTableName_Trig" 
 AFTER INSERT OR DELETE OR UPDATE ON "MyTableName"
 FOR EACH ROW EXECUTE PROCEDURE "recordchange" ();
diff --git a/contrib/dbmirror/DBMirror.pl b/contrib/dbmirror/DBMirror.pl
index a442502ba4..7eeffd7f48 100755
--- a/contrib/dbmirror/DBMirror.pl
+++ b/contrib/dbmirror/DBMirror.pl
@@ -33,7 +33,7 @@
 # 
 #
 ##############################################################################
-# $Id: DBMirror.pl,v 1.5 2002/12/05 21:03:51 momjian Exp $ 
+# $Id: DBMirror.pl,v 1.6 2003/05/14 03:25:55 tgl Exp $ 
 #
 ##############################################################################
 
@@ -135,15 +135,6 @@ sub Main() {
     die;
   }
     
-  my $setQuery2;
-  $setQuery2 = "SET autocommit TO 'on'";
-  my $setResult2 = $masterConn->exec($setQuery2);
-  if($setResult2->resultStatus!=PGRES_COMMAND_OK) { 
-    logErrorMessage($masterConn->errorMessage . "\n" . 
-		    $setQuery2);
-    die;
-  }
-    
   my $firstTime = 1;
   while(1) {
     if($firstTime == 0) {
@@ -158,7 +149,6 @@ sub Main() {
     
     
    
-    sendQueryToSlaves(undef,"SET autocommit TO 'on'");
     sendQueryToSlaves(undef,"SET TRANSACTION ISOLATION LEVEL SERIALIZABLE");
     sendQueryToSlaves(undef,"SET CONSTRAINTS ALL DEFERRED");
     
diff --git a/contrib/dbmirror/MirrorSetup.sql b/contrib/dbmirror/MirrorSetup.sql
index 7f54fa2967..4227ca5f39 100644
--- a/contrib/dbmirror/MirrorSetup.sql
+++ b/contrib/dbmirror/MirrorSetup.sql
@@ -1,6 +1,4 @@
 
-SET autocommit TO 'on';
-
 CREATE FUNCTION "recordchange" () RETURNS trigger AS
 '/usr/local/pgsql/lib/pending.so', 'recordchange' LANGUAGE 'C';
 
diff --git a/contrib/dbmirror/clean_pending.pl b/contrib/dbmirror/clean_pending.pl
index a74ea24700..9fba2610a1 100755
--- a/contrib/dbmirror/clean_pending.pl
+++ b/contrib/dbmirror/clean_pending.pl
@@ -16,7 +16,7 @@
 #    GNU General Public License for more details.
 #
 ##############################################################################
-# $Id: clean_pending.pl,v 1.2 2002/10/18 18:41:19 momjian Exp $
+# $Id: clean_pending.pl,v 1.3 2003/05/14 03:25:55 tgl Exp $
 ##############################################################################
 
 
@@ -69,10 +69,6 @@ unless($dbConn->status == PGRES_CONNECTION_OK) {
     printf("Can't connect to database\n");
     die;
 }
-my $setresult = $dbConn->exec("SET autocommit TO 'on'");
-unless($setresult->resultStatus == PGRES_COMMAND_OK) {
-   die $dbConn->errorMessage;
-}
 my $result = $dbConn->exec("BEGIN");
 unless($result->resultStatus == PGRES_COMMAND_OK) {
    die $dbConn->errorMessage;