liquid_feedback_core

annotate update/core-update.v2.0.1-v2.0.2.sql @ 295:69d6fba0f84c

find changesets by author, revision, files, or words in the commit message
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.
author jbe
date Thu Sep 13 17:02:22 2012 +0200 (2012-09-13)
parents 919d16c8e8e3
children
rev   line source
jbe@214 1 BEGIN;
jbe@214 2
jbe@214 3 -- update version number:
jbe@214 4 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
jbe@214 5 SELECT * FROM (VALUES ('2.0.2', 2, 0, 2))
jbe@214 6 AS "subquery"("string", "major", "minor", "revision");
jbe@214 7
jbe@214 8 -- add column "authentication" to table "member":
jbe@214 9 ALTER TABLE "member" ADD COLUMN "authentication" TEXT;
jbe@214 10 COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated';
jbe@214 11
jbe@214 12 COMMIT;

Impressum / About Us