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

Impressum / About Us