summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-02-07 09:29:16 +0100
committerYorhel <git@yorhel.nl>2011-02-07 09:29:16 +0100
commitdf4277ad295c1127e4b0d71cce49e889fa27dac9 (patch)
treed5b23dc8f739731b60f6e7ee7e2b7240cb715d8e /util
parentb53d0e8f54ca7e4cc397bb68638a19099f1cb160 (diff)
Bugfix: don't generate listdel notify for the user who deleted
Diffstat (limited to 'util')
-rw-r--r--util/sql/func.sql3
-rw-r--r--util/updates/update_2.18.sql3
2 files changed, 5 insertions, 1 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql
index 2f87bdb9..d7b5ab2f 100644
--- a/util/sql/func.sql
+++ b/util/sql/func.sql
@@ -763,7 +763,8 @@ BEGIN
JOIN (
SELECT id, title FROM vn_rev WHERE TG_TABLE_NAME = 'vn' AND vid = NEW.id
UNION SELECT id, title FROM releases_rev WHERE TG_TABLE_NAME = 'releases' AND rid = NEW.id
- ) x ON c.id = x.id;
+ ) x ON c.id = x.id
+ WHERE c.requester <> u.uid;
RETURN NULL;
END;
$$ LANGUAGE plpgsql;
diff --git a/util/updates/update_2.18.sql b/util/updates/update_2.18.sql
index c4cfe84f..90a5bcd3 100644
--- a/util/updates/update_2.18.sql
+++ b/util/updates/update_2.18.sql
@@ -3,3 +3,6 @@ CREATE TYPE tag_category AS ENUM('cont', 'ero', 'tech');
ALTER TABLE tags ADD COLUMN cat tag_category NOT NULL DEFAULT 'cont';
+-- load new function(s)
+\i util/sql/func.sql
+