diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-10-18 18:41:22 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-10-18 18:41:22 +0000 |
| commit | aa4c702eac936964649f905741b4a99f4b489200 (patch) | |
| tree | 517d3c28aa3d28eb95b19c8676c940b5cefe2031 /contrib/dbmirror/AddTrigger.sql | |
| parent | fb9bc342fffc157d6ca4b635aeeaccb3c1370b91 (diff) | |
| download | postgresql-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/AddTrigger.sql')
| -rw-r--r-- | contrib/dbmirror/AddTrigger.sql | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/contrib/dbmirror/AddTrigger.sql b/contrib/dbmirror/AddTrigger.sql index da786ec5dd..de07c3ae00 100644 --- a/contrib/dbmirror/AddTrigger.sql +++ b/contrib/dbmirror/AddTrigger.sql @@ -1,5 +1,9 @@ +-- Adjust this setting to control where the objects get created. +SET search_path = public; -CREATE TRIGGER "MyTableName_Trig" AFTER INSERT OR DELETE OR UPDATE -ON "MyTableName" FOR EACH ROW EXECUTE PROCEDURE -"recordchange" (); +SET autocommit TO 'on'; + +CREATE TRIGGER "MyTableName_Trig" +AFTER INSERT OR DELETE OR UPDATE ON "MyTableName" +FOR EACH ROW EXECUTE PROCEDURE "recordchange" (); |