liquid_feedback_core
changeset 326:d59d0c3e4a18
merge
author | jbe |
---|---|
date | Sun Feb 10 18:49:01 2013 +0100 (2013-02-10) |
parents | a0dd8c78bd10 6529e423f8eb |
children | ae0da58a9858 |
files | core.sql |
line diff
1.1 --- a/core.sql Sun Feb 10 18:41:56 2013 +0100 1.2 +++ b/core.sql Sun Feb 10 18:49:01 2013 +0100 1.3 @@ -3410,8 +3410,10 @@ 1.4 WHERE "issue_id" = "issue_id_p" 1.5 AND "event" = 'periodic'; 1.6 DELETE FROM "direct_supporter_snapshot" 1.7 - WHERE "issue_id" = "issue_id_p" 1.8 - AND "event" = 'periodic'; 1.9 + USING "initiative" -- NOTE: due to missing index on issue_id 1.10 + WHERE "initiative"."issue_id" = "issue_id_p" 1.11 + AND "direct_supporter_snapshot"."initiative_id" = "initiative"."id" 1.12 + AND "direct_supporter_snapshot"."event" = 'periodic'; 1.13 INSERT INTO "direct_interest_snapshot" 1.14 ("issue_id", "event", "member_id") 1.15 SELECT 1.16 @@ -3681,7 +3683,10 @@ 1.17 UPDATE "delegating_interest_snapshot" SET "event" = "event_p" 1.18 WHERE "issue_id" = "issue_id_p" AND "event" = "event_v"; 1.19 UPDATE "direct_supporter_snapshot" SET "event" = "event_p" 1.20 - WHERE "issue_id" = "issue_id_p" AND "event" = "event_v"; 1.21 + FROM "initiative" -- NOTE: due to missing index on issue_id 1.22 + WHERE "initiative"."issue_id" = "issue_id_p" 1.23 + AND "direct_supporter_snapshot"."initiative_id" = "initiative"."id" 1.24 + AND "direct_supporter_snapshot"."event" = "event_v"; 1.25 RETURN; 1.26 END; 1.27 $$; 1.28 @@ -4494,7 +4499,9 @@ 1.29 DELETE FROM "delegation" 1.30 WHERE "issue_id" = "issue_id_p"; 1.31 DELETE FROM "supporter" 1.32 - WHERE "issue_id" = "issue_id_p"; 1.33 + USING "initiative" 1.34 + WHERE "initiative"."issue_id" = "issue_id_p" 1.35 + AND "supporter"."initiative_id" = "initiative_id"; 1.36 UPDATE "issue" SET 1.37 "state" = "issue_row"."state", 1.38 "closed" = "issue_row"."closed",