liquid_feedback_core
diff core.sql @ 290:2301a1f2acfa
Modified function "forbid_changes_on_closed_issue_trigger" to allow voting comments to be changed after voting has finished
author | jbe |
---|---|
date | Sun Aug 19 23:37:37 2012 +0200 (2012-08-19) |
parents | f2292b94fc58 |
children | 86f231bd6906 |
line diff
1.1 --- a/core.sql Sun Aug 19 23:32:26 2012 +0200 1.2 +++ b/core.sql Sun Aug 19 23:37:37 2012 +0200 1.3 @@ -1576,6 +1576,15 @@ 1.4 "issue_id_v" "issue"."id"%TYPE; 1.5 "issue_row" "issue"%ROWTYPE; 1.6 BEGIN 1.7 + IF TG_RELID = 'direct_voter'::regclass AND TG_OP = 'UPDATE' THEN 1.8 + IF 1.9 + OLD."issue_id" = NEW."issue_id" AND 1.10 + OLD."member_id" = NEW."member_id" AND 1.11 + OLD."weight" = NEW."weight" 1.12 + THEN 1.13 + RETURN NULL; -- allows changing of voter comment 1.14 + END IF; 1.15 + END IF; 1.16 IF TG_OP = 'DELETE' THEN 1.17 "issue_id_v" := OLD."issue_id"; 1.18 ELSE