summaryrefslogtreecommitdiff
path: root/contrib/dbmirror/MirrorSetup.sql
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2002-10-18 18:41:22 +0000
committerBruce Momjian <bruce@momjian.us>2002-10-18 18:41:22 +0000
commitaa4c702eac936964649f905741b4a99f4b489200 (patch)
tree517d3c28aa3d28eb95b19c8676c940b5cefe2031 /contrib/dbmirror/MirrorSetup.sql
parentfb9bc342fffc157d6ca4b635aeeaccb3c1370b91 (diff)
downloadpostgresql-aa4c702eac936964649f905741b4a99f4b489200.tar.gz
Update /contrib for "autocommit TO 'on'".
Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
Diffstat (limited to 'contrib/dbmirror/MirrorSetup.sql')
-rw-r--r--contrib/dbmirror/MirrorSetup.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/contrib/dbmirror/MirrorSetup.sql b/contrib/dbmirror/MirrorSetup.sql
index 8e03264165..7597318411 100644
--- a/contrib/dbmirror/MirrorSetup.sql
+++ b/contrib/dbmirror/MirrorSetup.sql
@@ -1,4 +1,6 @@
+SET autocommit TO 'on';
+
CREATE FUNCTION "recordchange" () RETURNS trigger AS
'/usr/local/pgsql/lib/pending.so', 'recordchange' LANGUAGE 'C';