4
CREATE FUNCTION "recordchange" () RETURNS trigger AS
5
'$libdir/pending.so', 'recordchange' LANGUAGE 'C';
9
CREATE TABLE dbmirror_MirrorHost (
10
MirrorHostId serial not null,
11
SlaveName varchar NOT NULL,
12
PRIMARY KEY(MirrorHostId)
19
CREATE TABLE dbmirror_Pending (
21
TableName Name NOT NULL,
27
CREATE INDEX dbmirror_Pending_XID_Index ON dbmirror_Pending (XID);
29
CREATE TABLE dbmirror_PendingData (
33
PRIMARY KEY (SeqId, IsKey) ,
34
FOREIGN KEY (SeqId) REFERENCES dbmirror_Pending (SeqId) ON UPDATE CASCADE ON DELETE CASCADE
38
CREATE TABLE dbmirror_MirroredTransaction (
40
LastSeqId int4 NOT NULL,
41
MirrorHostId int4 NOT NULL,
42
PRIMARY KEY (XID,MirrorHostId),
43
FOREIGN KEY (MirrorHostId) REFERENCES dbmirror_MirrorHost (MirrorHostId) ON UPDATE CASCADE ON DELETE CASCADE,
44
FOREIGN KEY (LastSeqId) REFERENCES dbmirror_Pending (SeqId) ON UPDATE
45
CASCADE ON DELETE CASCADE
49
UPDATE pg_proc SET proname='nextval_pg' WHERE proname='nextval';
51
CREATE FUNCTION pg_catalog.nextval(text) RETURNS int8 AS
52
'$libdir/pending.so', 'nextval' LANGUAGE 'C' STRICT;
55
UPDATE pg_proc set proname='setval_pg' WHERE proname='setval';
57
CREATE FUNCTION pg_catalog.setval("unknown",integer,boolean) RETURNS int8 AS
58
'$libdir/pending.so', 'setval' LANGUAGE 'C' STRICT;
59
CREATE FUNCTION pg_catalog.setval("unknown",integer) RETURNS int8 AS
60
'$libdir/pending.so', 'setval' LANGUAGE 'C' STRICT;