# HG changeset patch # User jbe # Date 1581432093 -3600 # Node ID f69e0d9e5bb3e333dcda53eac821c31e9d0a77c4 # Parent 617ac1725557abefb02d8c80523364322a471bdf Removed transaction around ALTER TYPE for compatibility with older PostgreSQL versions diff -r 617ac1725557 -r f69e0d9e5bb3 update/core-update.v4.1.0-v4.2.0.sql --- a/update/core-update.v4.1.0-v4.2.0.sql Mon Feb 10 20:33:10 2020 +0100 +++ b/update/core-update.v4.1.0-v4.2.0.sql Tue Feb 11 15:41:33 2020 +0100 @@ -1,13 +1,9 @@ -BEGIN; - CREATE OR REPLACE VIEW "liquid_feedback_version" AS SELECT * FROM (VALUES ('4.2.0-incomplete-update', 4, 2, -1)) AS "subquery"("string", "major", "minor", "revision"); ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'posting_created'; -COMMIT; - BEGIN; CREATE OR REPLACE VIEW "liquid_feedback_version" AS