| age | 
  author | 
  description | 
 
 
  | 2013-03-17 | 
  jbe | 
  Optional logging in "lf_update_suggestion_order" | 
 
 
  | 2013-03-17 | 
  jbe | 
  Fixed bug in while loop of "loser" function of lf_update_suggestion_order.c, that has been introduced in last commit | 
 
 
  | 2013-03-17 | 
  jbe | 
  Added comments to lf_update_suggestion_order.c | 
 
 
  | 2013-03-17 | 
  jbe | 
  For suggestions without individual rankings, set "proportional_order" to zero instead of NULL | 
 
 
  | 2013-03-17 | 
  jbe | 
  Bugfix in "lf_update_suggestion_order" related to floating point error workaround | 
 
 
  | 2013-03-17 | 
  jbe | 
  Bugfix: Numerical ordering of suggestion_id in "lf_update_suggestion_order" | 
 
 
  | 2013-03-17 | 
  jbe | 
  In "lf_update_suggestion_order" take ballot weight into account | 
 
 
  | 2013-03-17 | 
  jbe | 
  Bugfix in "lf_update_suggestion_order": Set candidate_count to zero, also in cases where no tuples are returned | 
 
 
  | 2013-03-17 | 
  jbe | 
  Fixed errors in function "process_initiative" of "lf_update_suggestion_order", which caused memory access errors | 
 
 
  | 2013-03-17 | 
  jbe | 
  Bugfix in function "process_initiative" of "lf_update_suggestion_order": Reset old_member_id to NULL | 
 
 
  | 2013-03-17 | 
  jbe | 
  Added "lf_update_suggestion_order" to clean taget of makefile | 
 
 
  | 2013-03-17 | 
  jbe | 
  Removed unused variable in "lf_update_suggestion_order" | 
 
 
  | 2013-03-17 | 
  jbe | 
  Help output of "lf_update" and "lf_update_suggestion_order" either to stdout or stderr, depending on invocation | 
 
 
  | 2013-03-17 | 
  jbe | 
  Include "final" flag in debug output of "lf_update_suggestion_order" | 
 
 
  | 2013-03-17 | 
  jbe | 
  Update script to v2.2.1 | 
 
 
  | 2013-03-17 | 
  jbe | 
  Write "final_suggestion_order_calculated" flag in "lf_update_suggestion_order" | 
 
 
  | 2013-03-17 | 
  jbe | 
  Write ranks to database in "lf_update_suggestion_order" | 
 
 
  | 2013-03-17 | 
  jbe | 
  Handle out-of-memory errors in "lf_update" when escaping string literals | 
 
 
  | 2013-03-17 | 
  jbe | 
  Calculation of ranks in "lf_update_suggestion_order" | 
 
 
  | 2013-03-16 | 
  jbe | 
  Code cleanup in "lf_update_suggestion_order" (own block for preparation of the ballot data) | 
 
 
  | 2013-03-16 | 
  jbe | 
  Free memory for candidate and ballot structure in "lf_update_suggestion_order" | 
 
 
  | 2013-03-16 | 
  jbe | 
  Extended "lf_update_suggestion_order" to create a candidate structure | 
 
 
  | 2013-03-16 | 
  jbe | 
  Support for proportional ordering of suggestions in core.sql; Begin of work on "lf_update_suggestion_order" (a second background job for sorting suggestions based on a proportional preferential voting system) | 
 
 
  | 2013-03-10 | 
  jbe | 
  Added tag v2.2.0 for changeset 49c25dbc27bc | 
 
 
  | 2013-03-10 | 
  jbe | 
  Added reminder to make backups before installing updatesv2.2.0  | 
 
 
  | 2013-03-09 | 
  jbe | 
  Bugfix for calculation of harmonic_weight, when there are initiatives without supporters | 
 
 
  | 2013-03-09 | 
  jbe | 
  Updated LICENSE file | 
 
 
  | 2013-02-21 | 
  jbe | 
  Execute update script from v2.1.0 to v2.2.0 in isolation level REPEATABLE READ | 
 
 
  | 2013-02-21 | 
  jbe | 
  Set harmonic_weight for all issues in update script to v2.2.0 | 
 
 
  | 2013-02-21 | 
  jbe | 
  Compatibility for PostgreSQL 8.4 in lf_update.c | 
 
 
  | 2013-02-21 | 
  jbe | 
  Added comments for functions "require_transaction_isolation"() and "dont_require_transaction_isolation"() | 
 
 
  | 2013-02-21 | 
  jbe | 
  Changed indentation in "check_issue" function code | 
 
 
  | 2013-02-21 | 
  jbe | 
  Removed unnecessary code, because multiple phase changes at once are no longer possible | 
 
 
  | 2013-02-21 | 
  jbe | 
  Write "NOW()" as "now()" | 
 
 
  | 2013-02-21 | 
  jbe | 
  Code formatting of constraint "valid_state" in table "issue" | 
 
 
  | 2013-02-21 | 
  jbe | 
  Update script to v2.2.0 | 
 
 
  | 2013-02-21 | 
  jbe | 
  Removed setting of "ranks_available" column in function "clean_issue" | 
 
 
  | 2013-02-20 | 
  jbe | 
  Removed deprecated timeline views | 
 
 
  | 2013-02-20 | 
  jbe | 
  Cleanup of new code for allowing "lf_update" to run without extensive locking | 
 
 
  | 2013-02-19 | 
  jbe | 
  Removed debug code in lf_update.c | 
 
 
  | 2013-02-19 | 
  jbe | 
  Use different transaction isolation levels in "lf_update" program | 
 
 
  | 2013-02-15 | 
  jbe | 
  Completely removed table locking in favor of transaction isolation requirements | 
 
 
  | 2013-02-15 | 
  jbe | 
  Bugfixes for new system to allow the background job (lf_update) run without intensive locking | 
 
 
  | 2013-02-14 | 
  jbe | 
  Work on new system to allow the background job (lf_update) run without intensive locking (incomplete yet) | 
 
 
  | 2013-02-11 | 
  jbe | 
  Removed locking system | 
 
 
  | 2013-02-10 | 
  jbe | 
  Added comment in "clean_issue" function | 
 
 
  | 2013-02-10 | 
  jbe | 
  Stub (no implementation yet) for "phase_finished" field, allowing calculations to take more time without database locking | 
 
 
  | 2013-02-10 | 
  jbe | 
  Correct index usage when calculating "harmonic_weight" | 
 
 
  | 2013-02-10 | 
  jbe | 
  merge | 
 
 
  | 2013-02-10 | 
  jbe | 
  Bugfix regarding index usage (speeds up lf_update) | 
 
 
  | 2013-02-10 | 
  jbe | 
  Removed update script to v2.1.1 due to upcoming major changes | 
 
 
  | 2013-02-09 | 
  jbe | 
  Removed "harmonic_weight" for suggestions, because another proportional ranking algorithm is needed there | 
 
 
  | 2013-02-08 | 
  jbe | 
  Calculate "harmonc_weight" after all other calculations in an issue (as calculation depends on the "admitted" flag now) | 
 
 
  | 2013-02-08 | 
  jbe | 
  Require "satisfied" support for "admitted" initiatives when calculating "harmonic_weight" | 
 
 
  | 2013-02-08 | 
  jbe | 
  Calculate "harmonic_weight" to be used as a secondary sorting key, while the "admitted" flag shall be used as the primary sorting key for initiatives | 
 
 
  | 2013-02-02 | 
  jbe | 
  Bugfix in view "remaining_harmonic_suggestion_weight_summands" | 
 
 
  | 2013-02-02 | 
  jbe | 
  Bugfix in view "remaining_harmonic_opinion_weight" | 
 
 
  | 2013-02-02 | 
  jbe | 
  Count non-fulfilled suggestions with positive opinion and fulfilled suggestions with negative opinion for "harmonic_weight" of suggestions | 
 
 
  | 2013-02-02 | 
  jbe | 
  Set "harmonic_weight" to zero instead of null, where there are no supporters | 
 
 
  | 2013-02-01 | 
  jbe | 
  Update script for "harmonic_weight" feature | 
 
 
  | 2013-02-01 | 
  jbe | 
  Minor fix in comment | 
 
 
  | 2013-02-01 | 
  jbe | 
  Changed rounding behaviour for "harmonic_weight" | 
 
 
  | 2013-02-01 | 
  jbe | 
  Added "harmonic_weight" for suggestions; Bugfix in function "set_harmonic_initiative_weights" (clear weights prior calculation) | 
 
 
  | 2013-02-01 | 
  jbe | 
  Removed debug notice in function "set_harmonic_initiative_weights" | 
 
 
  | 2013-02-01 | 
  jbe | 
  "harmonic_weight" for initiatives | 
 
 
  | 2012-10-15 | 
  jbe | 
  Added tag v2.1.0 for changeset 5c98265b39a0 | 
 
 
  | 2012-10-06 | 
  jbe | 
  Added missing DROP FUNCTION "vote_ratio" in update scriptsv2.1.0  | 
 
 
  | 2012-10-05 | 
  jbe | 
  Merged fix from v2.0.12: Removed unwanted (and broken) tie-breaking by approval rate | 
 
 
  | 2012-10-05 | 
  jbe | 
  Added tag v2.0.12 for changeset a839e7efde9f | 
 
 
  | 2012-10-05 | 
  jbe | 
  Removed unwanted (and broken) tie-breaking by approval ratev2.0.12  | 
 
 
  | 2012-09-30 | 
  jbe | 
  Removed broken tie-breaking implementation | 
 
 
  | 2012-09-30 | 
  jbe | 
  Added TODO for broken implementation of tie-breaking | 
 
 
  | 2012-09-29 | 
  jbe | 
  Better tie-breaking | 
 
 
  | 2012-09-25 | 
  jbe | 
  merge: Switched order of row-level and table-level member locking | 
 
 
  | 2012-09-25 | 
  jbe | 
  Switched order of row-level and table-level member locking | 
 
 
  | 2012-09-25 | 
  jbe | 
  merge: In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level SHARE locks | 
 
 
  | 2012-09-25 | 
  jbe | 
  In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level share locks | 
 
 
  | 2012-09-25 | 
  jbe | 
  Different locking levels and different locking order in function "lock_issue"("issue"."id") to avoid deadlocks | 
 
 
  | 2012-09-24 | 
  jbe | 
  Use SHARE MODE table locks in function "lock_issue"("issue"."id") for tables neither referenced nor changed | 
 
 
  | 2012-09-13 | 
  jbe | 
  Use EXCLUSIVE MODE table locks in function "lock_issue"("issue"."id") | 
 
 
  | 2012-08-26 | 
  jbe | 
  Correctly transform existing "contingent" entries when updating to v2.1.0 | 
 
 
  | 2012-08-25 | 
  jbe | 
  Split contingent into polling and non-polling contingent | 
 
 
  | 2012-08-20 | 
  jbe | 
  No "issue_quorum" for polling policies | 
 
 
  | 2012-08-20 | 
  jbe | 
  Issues may have an admission_time set to NULL | 
 
 
  | 2012-08-19 | 
  jbe | 
  Modified function "forbid_changes_on_closed_issue_trigger" to allow voting comments to be changed after voting has finished | 
 
 
  | 2012-08-19 | 
  jbe | 
  Updated comments for polling mode in core.sql and core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Changed order of "close_voting" and "clean_issue" functions in update/core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Commented update/core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Deprecated old API tables in update script update/core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Moved voting comment to table "direct_voter" | 
 
 
  | 2012-08-19 | 
  jbe | 
  "non_voter" deletes "direct_voter" and vice versa | 
 
 
  | 2012-08-19 | 
  jbe | 
  Included changed comment on function "delete_private_data"() in core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Removed preliminary API tables for upcoming release (will be included later) | 
 
 
  | 2012-08-15 | 
  jbe | 
  URL for registered (web) API clients | 
 
 
  | 2012-08-15 | 
  jbe | 
  Unique "client_identifier" for "registered_client", No foreign key in table "authorized_client" | 
 
 
  | 2012-08-15 | 
  jbe | 
  Work on tables for OAuth2 |