diff options
author | Yorhel <git@yorhel.nl> | 2011-02-14 12:41:51 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-02-14 12:41:51 +0100 |
commit | a796407a552fb5422a81a4cf8a5029d1f39bf419 (patch) | |
tree | 3cecfab0db7d361851826f2e28d16c34c1390b09 /util | |
parent | 23c6f7c1dc584fab42d87f060a9faa033e04c8e2 (diff) |
chardb: Made Multi aware of traits
Added new trait notify and i+ id-matching
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/func.sql | 4 | ||||
-rw-r--r-- | util/updates/update_2.19.sql | 5 |
2 files changed, 8 insertions, 1 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index d7b5ab2f..74f08147 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -590,7 +590,7 @@ $$ LANGUAGE plpgsql; --- NOTIFY on insert into changes/posts/tags +-- NOTIFY on insert into changes/posts/tags/trait CREATE OR REPLACE FUNCTION insert_notify() RETURNS trigger AS $$ BEGIN IF TG_TABLE_NAME = 'changes' THEN @@ -599,6 +599,8 @@ BEGIN NOTIFY newpost; ELSIF TG_TABLE_NAME = 'tags' THEN NOTIFY newtag; + ELSIF TG_TABLE_NAME = 'traits' THEN + NOTIFY newtrait; END IF; RETURN NULL; END; diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql index 9819f685..4bb7f547 100644 --- a/util/updates/update_2.19.sql +++ b/util/updates/update_2.19.sql @@ -24,3 +24,8 @@ CREATE TABLE traits_parents ( PRIMARY KEY(trait, parent) ); +\i util/sql/func.sql + +CREATE TRIGGER insert_notify AFTER INSERT ON traits FOR EACH STATEMENT EXECUTE PROCEDURE insert_notify(); + + |