summaryrefslogtreecommitdiff
path: root/util/sql/func.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/sql/func.sql')
-rw-r--r--util/sql/func.sql3
1 files changed, 2 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;