liquid_feedback_core
annotate update/core-update.v1.0.2-v1.0.3.sql @ 295:69d6fba0f84c
Use EXCLUSIVE MODE table locks in function "lock_issue"("issue"."id")
Avoids deadlocks caused by explicit FOR UPDATE row locks when updating member statements and implicit FOR SHARE row locks when writing snapshots.
Avoids deadlocks caused by explicit FOR UPDATE row locks when updating member statements and implicit FOR SHARE row locks when writing snapshots.
| author | jbe |
|---|---|
| date | Thu Sep 13 17:02:22 2012 +0200 (2012-09-13) |
| parents | 3fbf9e18ee52 |
| children |
| rev | line source |
|---|---|
| jbe@52 | 1 BEGIN; |
| jbe@52 | 2 |
| jbe@52 | 3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS |
| jbe@52 | 4 SELECT * FROM (VALUES ('1.0.3', 1, 0, 3)) |
| jbe@52 | 5 AS "subquery"("string", "major", "minor", "revision"); |
| jbe@52 | 6 |
| jbe@52 | 7 DROP INDEX "delegating_voter_member_id_idx"; |
| jbe@52 | 8 CREATE INDEX "delegating_voter_member_id_idx" ON "delegating_voter" ("member_id"); |
| jbe@52 | 9 |
| jbe@52 | 10 COMMIT; |