From 90ef9c7da3de2c5800a82d911cd18ca1cf1850e2 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 10 Nov 2010 11:45:28 +0300 Subject: schema: wrap upgrade scripts in transaction blocks --- schema/versions/pgsql/72.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'schema/versions/pgsql/72.sql') diff --git a/schema/versions/pgsql/72.sql b/schema/versions/pgsql/72.sql index 7b260b3d1..65e4d2e0a 100644 --- a/schema/versions/pgsql/72.sql +++ b/schema/versions/pgsql/72.sql @@ -1,5 +1,9 @@ +begin; + alter table ttrss_user_entries add column tag_cache text; update ttrss_user_entries set tag_cache = ''; alter table ttrss_user_entries alter column tag_cache set not null; update ttrss_version set schema_version = 72; + +commit; -- cgit v1.2.3