summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-11-28 10:44:13 +0100
committerYorhel <git@yorhel.nl>2010-11-28 10:44:13 +0100
commit5bfd8f4559f2ce54332d28ac767619c020b151dc (patch)
tree945e4eeb078e5f9621bf8947b6b0d30c508f8011 /util
parent21ce1b44379f914a36c3b8335cc93aa21d96c9b3 (diff)
ChangeLog update for 2.14 + some minor upgrade fixes
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.14.sql5
1 files changed, 4 insertions, 1 deletions
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;