liquid_feedback_core

changeset 151:dca335a33e0b

Bugfix in function "clean_issue": Temporarily update "issue"."state" to avoid constraint violation
author jbe
date Thu Jun 02 02:33:10 2011 +0200 (2011-06-02)
parents a426ce0124a2
children c7dbb24108de
files core.sql
line diff
     1.1 --- a/core.sql	Thu Jun 02 02:16:11 2011 +0200
     1.2 +++ b/core.sql	Thu Jun 02 02:33:10 2011 +0200
     1.3 @@ -4035,9 +4035,9 @@
     1.4          FROM "issue" WHERE "id" = "issue_id_p"
     1.5          FOR UPDATE;
     1.6        IF "issue_row"."cleaned" ISNULL THEN
     1.7 -        -- TODO: might be broken due to new constraints!
     1.8          UPDATE "issue" SET
     1.9 -          "closed" = NULL,
    1.10 +          "state"           = 'voting',
    1.11 +          "closed"          = NULL,
    1.12            "ranks_available" = FALSE
    1.13            WHERE "id" = "issue_id_p";
    1.14          DELETE FROM "delegating_voter"
    1.15 @@ -4059,6 +4059,7 @@
    1.16          DELETE FROM "supporter"
    1.17            WHERE "issue_id" = "issue_id_p";
    1.18          UPDATE "issue" SET
    1.19 +          "state"           = "issue_row"."state",
    1.20            "closed"          = "issue_row"."closed",
    1.21            "ranks_available" = "issue_row"."ranks_available",
    1.22            "cleaned"         = now()

Impressum / About Us