summaryrefslogtreecommitdiff
path: root/contrib/dbmirror/MirrorSetup.sql
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2002-10-19 02:16:40 +0000
committerBruce Momjian <bruce@momjian.us>2002-10-19 02:16:40 +0000
commit8e6b5c8b2763fccdaa6e15b055b244b5c9b8778c (patch)
treeda98a122ff53257b0b60f854df8188d1c5ae5495 /contrib/dbmirror/MirrorSetup.sql
parentcabad378fcda93902b64993df547bc173228fcab (diff)
downloadpostgresql-8e6b5c8b2763fccdaa6e15b055b244b5c9b8778c.tar.gz
It includes
-Support for mirroring tables in different Schema's -Improved documentation for compiling with 7.1.x and 7.2.x -Fixes a buffer overrun bug. Steven Singer
Diffstat (limited to 'contrib/dbmirror/MirrorSetup.sql')
-rw-r--r--contrib/dbmirror/MirrorSetup.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/contrib/dbmirror/MirrorSetup.sql b/contrib/dbmirror/MirrorSetup.sql
index 7597318411..7f54fa2967 100644
--- a/contrib/dbmirror/MirrorSetup.sql
+++ b/contrib/dbmirror/MirrorSetup.sql
@@ -6,7 +6,8 @@ CREATE FUNCTION "recordchange" () RETURNS trigger AS
CREATE TABLE "MirrorHost" (
"MirrorHostId" serial,
-"HostName" varchar NOT NULL
+"HostName" varchar NOT NULL,
+PRIMARY KEY("MirrorHostId")
);