Attached is a 1 line bug fix for dbmirror that was submitted.
It fixes a bug where some transactions could be dropped when writing 
mirrored SQL statements to files.



-- 
Steven Singer                                       [EMAIL PROTECTED]
Dispatch Systems                            Phone:  519-747-1170 ext 282
Navtech Systems Support Inc.                AFTN:   CYYZXNSX SITA: YYZNSCR
Waterloo, Ontario                           ARINC:  YKFNSCR
Index: DBMirror.pl
===================================================================
RCS file: /projects/cvsroot/pgsql-server/contrib/dbmirror/DBMirror.pl,v
retrieving revision 1.9
diff -u -r1.9 DBMirror.pl
--- DBMirror.pl 22 Apr 2004 03:48:38 -0000      1.9
+++ DBMirror.pl 1 Jul 2004 01:31:27 -0000
@@ -249,6 +249,8 @@
       if($::slaveInfo->{'status'} eq 'FileOpen')
       {
          close ($::slaveInfo->{'TransactionFile'});
+          $::slaveInfo->{"status"} = 'FileClosed';
+
       }
       elsif($::slaveInfo->{'status'} eq 'DBOpen')
       {
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to