summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-02-14 12:41:51 +0100
committerYorhel <git@yorhel.nl>2011-02-14 12:41:51 +0100
commita796407a552fb5422a81a4cf8a5029d1f39bf419 (patch)
tree3cecfab0db7d361851826f2e28d16c34c1390b09 /util
parent23c6f7c1dc584fab42d87f060a9faa033e04c8e2 (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.sql4
-rw-r--r--util/updates/update_2.19.sql5
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();
+
+