From 5bfd8f4559f2ce54332d28ac767619c020b151dc Mon Sep 17 00:00:00 2001 From: Yorhel Date: Sun, 28 Nov 2010 10:44:13 +0100 Subject: ChangeLog update for 2.14 + some minor upgrade fixes --- util/updates/update_2.14.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'util') diff --git a/util/updates/update_2.14.sql b/util/updates/update_2.14.sql index 2233e0a8..ea06e689 100644 --- a/util/updates/update_2.14.sql +++ b/util/updates/update_2.14.sql @@ -1,6 +1,5 @@ -- add vn.c_olang - ALTER TABLE vn ADD COLUMN c_olang language[] NOT NULL DEFAULT '{}'; @@ -8,6 +7,10 @@ ALTER TABLE vn ADD COLUMN c_olang language[] NOT NULL DEFAULT '{}'; \i util/sql/func.sql +-- regenerate vn.c_* columns +SELECT COUNT(*) FROM (SELECT update_vncache(id) FROM vn WHERE NOT hidden) s; + + -- redefine the triggers to use the new conditional triggers in PostgreSQL 9.0 DROP TRIGGER hidlock_update ON vn; -- cgit v1.2.3