liquid_feedback_core

diff core.sql @ 129:07cfc7c1ce3f

Bugfix in function "close_voting" related to selection of "area_id" and "unit_id"

Includes update script to v1.4.0_rc2
author jbe
date Tue May 24 23:13:06 2011 +0200 (2011-05-24)
parents 1af27a67ee1a
children 284113a50c3b 0fa3c4739ca7
line diff
     1.1 --- a/core.sql	Sun Mar 13 13:29:33 2011 +0100
     1.2 +++ b/core.sql	Tue May 24 23:13:06 2011 +0200
     1.3 @@ -7,7 +7,7 @@
     1.4  BEGIN;
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('1.4.0_rc1', 1, 4, -1))
     1.8 +  SELECT * FROM (VALUES ('1.4.0_rc2', 1, 4, -1))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
    1.12 @@ -3405,8 +3405,8 @@
    1.13        "member_id_v" "member"."id"%TYPE;
    1.14      BEGIN
    1.15        PERFORM "lock_issue"("issue_id_p");
    1.16 -      SELECT "id" INTO "area_id_v" FROM "issue" WHERE "id" = "issue_id_p";
    1.17 -      SELECT "id" INTO "unit_id_v" FROM "area"  WHERE "id" = "area_id_v";
    1.18 +      SELECT "area_id" INTO "area_id_v" FROM "issue" WHERE "id" = "issue_id_p";
    1.19 +      SELECT "unit_id" INTO "unit_id_v" FROM "area"  WHERE "id" = "area_id_v";
    1.20        DELETE FROM "delegating_voter"
    1.21          WHERE "issue_id" = "issue_id_p";
    1.22        DELETE FROM "direct_voter"

Impressum / About Us