liquid_feedback_core

diff core.sql @ 582:225a0c047691

Bugfix in function "write_event_initiative_revoked_trigger" (wrong use of SELECT, needs to be PERFORM)
author jbe
date Tue Sep 04 14:30:41 2018 +0200 (2018-09-04)
parents 1cb6710fc429
children f5095a9696eb
line diff
     1.1 --- a/core.sql	Sun Mar 04 18:10:07 2018 +0100
     1.2 +++ b/core.sql	Tue Sep 04 14:30:41 2018 +0200
     1.3 @@ -1999,13 +1999,13 @@
     1.4      BEGIN
     1.5        IF OLD."revoked" ISNULL AND NEW."revoked" NOTNULL THEN
     1.6          -- NOTE: lock for primary key update to avoid new drafts
     1.7 -        SELECT NULL FROM "initiative" WHERE "id" = NEW."id" FOR UPDATE;
     1.8 +        PERFORM NULL FROM "initiative" WHERE "id" = NEW."id" FOR UPDATE;
     1.9          SELECT * INTO "issue_row" FROM "issue"
    1.10            WHERE "id" = NEW."issue_id" FOR SHARE;
    1.11          SELECT * INTO "area_row" FROM "area"
    1.12            WHERE "id" = "issue_row"."area_id" FOR SHARE;
    1.13          -- NOTE: FOR SHARE cannot be used with DISTINCT in view "current_draft"
    1.14 -        SELECT NULL FROM "draft" WHERE "initiative_id" = NEW."id" FOR SHARE;
    1.15 +        PERFORM NULL FROM "draft" WHERE "initiative_id" = NEW."id" FOR SHARE;
    1.16          SELECT "id" INTO "draft_id_v" FROM "current_draft"
    1.17            WHERE "initiative_id" = NEW."id";
    1.18          INSERT INTO "event" (

Impressum / About Us