Attatched is a patch for contrib/dbmirror that should be applied against
the 7.4 tree
A) Fixes a bug that prevented mirroring of data on a table that has had a
column dropped.
B) Updated the documentation for the 7.4 release.
Thanks
--
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: pending.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/contrib/dbmirror/pending.c,v
retrieving revision 1.13
diff -c -r1.13 pending.c
*** pending.c 4 Aug 2003 00:43:10 -0000 1.13
--- pending.c 13 Sep 2003 14:50:22 -0000
***************
*** 437,442 ****
--- 437,452 ----
continue;
}
} /* KeyUsage!=ALL */
+ #ifndef NODROPCOLUMN
+ if(tTupleDesc->attrs[iColumnCounter-1]->attisdropped)
+ {
+ /**
+ * This column has been dropped.
+ * Do not mirror it.
+ */
+ continue;
+ }
+ #endif
cpFieldName = DatumGetPointer(NameGetDatum(&tTupleDesc->attrs
[iColumnCounter - 1]->attname));
#if defined DEBUG_OUTPUT
Index: README.dbmirror
===================================================================
RCS file: /projects/cvsroot/pgsql-server/contrib/dbmirror/README.dbmirror,v
retrieving revision 1.5
diff -c -r1.5 README.dbmirror
*** README.dbmirror 6 Nov 2002 17:50:53 -0000 1.5
--- README.dbmirror 13 Sep 2003 14:50:23 -0000
***************
*** 66,72 ****
To build the trigger run make on the "Makefile" in the DBMirror directory.
! Postgres-7.3 Make Instructions:
If you have already run "configure" in the pgsql-server directory
then run "make" in the dbmirror directory to compile the trigger.
--- 66,72 ----
To build the trigger run make on the "Makefile" in the DBMirror directory.
! Postgres-7.3 & 7.4 Make Instructions:
If you have already run "configure" in the pgsql-server directory
then run "make" in the dbmirror directory to compile the trigger.
***************
*** 78,84 ****
Run the following commands
! gcc -fpic -I/usr/local/pgsql/include/server -c pending.c -DNOSCHEMAS
ld -shared -o pending.so pending.o
Assuming the postgres include files are in /usr/local/pgsql/include/server.
--- 78,84 ----
Run the following commands
! gcc -fpic -I/usr/local/pgsql/include/server -c pending.c -DNOSCHEMAS -DNODROPCOLUMN
ld -shared -o pending.so pending.o
Assuming the postgres include files are in /usr/local/pgsql/include/server.
***************
*** 236,241 ****
--- 236,242 ----
Mandrake Linux 8.0(Limited Testing)
-Postgres 7.2
-Postgres 7.3
+ -Postgres 7.4
-Perl 5.6
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
