summaryrefslogtreecommitdiff
path: root/sql/triggers.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/triggers.sql')
-rw-r--r--sql/triggers.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/triggers.sql b/sql/triggers.sql
index eeb0c411..bfda6354 100644
--- a/sql/triggers.sql
+++ b/sql/triggers.sql
@@ -299,7 +299,7 @@ BEGIN
UPDATE reviews
SET c_count = COALESCE((SELECT COUNT(*) FROM reviews_posts WHERE NOT hidden AND id = reviews.id), 0)
, c_lastnum = (SELECT MAX(num) FROM reviews_posts WHERE NOT hidden AND id = reviews.id)
- WHERE id IN(OLD.tid,NEW.tid);
+ WHERE id IN(OLD.id,NEW.id);
RETURN NULL;
END
$$ LANGUAGE plpgsql;