# HG changeset patch # User jbe # Date 1506622343 -7200 # Node ID 797282760db4040e3c764343634a0387ec77366d # Parent 74f98b2196ef97b9b5e473ee48b6c1c3b9bd7696 Removed unused function "calculate_area_quorum" (done by function "issue_admission") diff -r 74f98b2196ef -r 797282760db4 core.sql --- a/core.sql Wed Sep 27 15:32:36 2017 +0200 +++ b/core.sql Thu Sep 28 20:12:23 2017 +0200 @@ -4666,21 +4666,6 @@ COMMENT ON FUNCTION "calculate_member_counts"() IS 'Updates "member_count" table and "member_count" column of table "area" by materializing data from views "member_count_view" and "unit_member_count"'; -CREATE FUNCTION "calculate_area_quorum"() - RETURNS VOID - LANGUAGE 'plpgsql' VOLATILE AS $$ - BEGIN - PERFORM "dont_require_transaction_isolation"(); - UPDATE "area" SET "issue_quorum" = "view"."issue_quorum" - FROM "area_quorum" AS "view" - WHERE "view"."area_id" = "area"."id"; - RETURN; - END; - $$; - -COMMENT ON FUNCTION "calculate_area_quorum"() IS 'Calculate column "issue_quorum" in table "area" from view "area_quorum"'; - - ------------------------------------ -- Calculation of harmonic weight -- diff -r 74f98b2196ef -r 797282760db4 update/core-update.v3.2.2-v4.0.0.sql --- a/update/core-update.v3.2.2-v4.0.0.sql Wed Sep 27 15:32:36 2017 +0200 +++ b/update/core-update.v3.2.2-v4.0.0.sql Thu Sep 28 20:12:23 2017 +0200 @@ -2531,21 +2531,6 @@ COMMENT ON FUNCTION "calculate_member_counts"() IS 'Updates "member_count" table and "member_count" column of table "area" by materializing data from views "member_count_view" and "unit_member_count"'; -CREATE FUNCTION "calculate_area_quorum"() - RETURNS VOID - LANGUAGE 'plpgsql' VOLATILE AS $$ - BEGIN - PERFORM "dont_require_transaction_isolation"(); - UPDATE "area" SET "issue_quorum" = "view"."issue_quorum" - FROM "area_quorum" AS "view" - WHERE "view"."area_id" = "area"."id"; - RETURN; - END; - $$; - -COMMENT ON FUNCTION "calculate_area_quorum"() IS 'Calculate column "issue_quorum" in table "area" from view "area_quorum"'; - - DROP VIEW "remaining_harmonic_initiative_weight_summands"; DROP VIEW "remaining_harmonic_supporter_weight";