diff options
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" (); |