diff options
Diffstat (limited to 'util/sql/func.sql')
-rw-r--r-- | util/sql/func.sql | 3 |
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; |