Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit04e401f

Browse files
committed
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.Steven Singer
1 parentb8d7e1e commit04e401f

File tree

2 files changed

+14
-3
lines changed

2 files changed

+14
-3
lines changed

‎contrib/dbmirror/README.dbmirror

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -66,7 +66,7 @@ time a row inside of a table being mirrored changes.
6666

6767
To build the trigger run make on the "Makefile" in the DBMirror directory.
6868

69-
Postgres-7.3 Make Instructions:
69+
Postgres-7.3& 7.4Make Instructions:
7070

7171
If you have already run "configure" in the pgsql-server directory
7272
then run "make" in the dbmirror directory to compile the trigger.
@@ -78,7 +78,7 @@ Postgres-7.1 & Postgres-7.2 Make Instructions:
7878

7979
Run the following commands
8080

81-
gcc -fpic -I/usr/local/pgsql/include/server -c pending.c -DNOSCHEMAS
81+
gcc -fpic -I/usr/local/pgsql/include/server -c pending.c -DNOSCHEMAS -DNODROPCOLUMN
8282
ld -shared -o pending.so pending.o
8383

8484
Assuming the postgres include files are in /usr/local/pgsql/include/server.
@@ -236,6 +236,7 @@ RedHat Linux 7.1 & 6.2
236236
Mandrake Linux 8.0(Limited Testing)
237237
-Postgres 7.2
238238
-Postgres 7.3
239+
-Postgres 7.4
239240
-Perl 5.6
240241

241242

‎contrib/dbmirror/pending.c

Lines changed: 11 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
/****************************************************************************
22
* pending.c
3-
* $Id: pending.c,v 1.13 2003/08/04 00:43:10 momjian Exp $
3+
* $Id: pending.c,v 1.14 2003/09/29 18:16:48 momjian Exp $
44
*
55
* This file contains a trigger for Postgresql-7.x to record changes to tables
66
* to a pending table for mirroring.
@@ -437,6 +437,16 @@ packageData(HeapTuple tTupleData, TupleDesc tTupleDesc,
437437
continue;
438438
}
439439
}/* KeyUsage!=ALL */
440+
#ifndefNODROPCOLUMN
441+
if(tTupleDesc->attrs[iColumnCounter-1]->attisdropped)
442+
{
443+
/**
444+
* This column has been dropped.
445+
* Do not mirror it.
446+
*/
447+
continue;
448+
}
449+
#endif
440450
cpFieldName=DatumGetPointer(NameGetDatum(&tTupleDesc->attrs
441451
[iColumnCounter-1]->attname));
442452
#if definedDEBUG_OUTPUT

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp