summaryrefslogtreecommitdiff
path: root/util/updates/update_2.14.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/update_2.14.sql')
-rw-r--r--util/updates/update_2.14.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/util/updates/update_2.14.sql b/util/updates/update_2.14.sql
index ea06e689..e8930843 100644
--- a/util/updates/update_2.14.sql
+++ b/util/updates/update_2.14.sql
@@ -7,10 +7,6 @@ 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;
@@ -143,3 +139,7 @@ ALTER TABLE votes ADD FOREIGN KEY (uid) REFERENCES users
ALTER TABLE wlists DROP CONSTRAINT wlists_uid_fkey;
ALTER TABLE wlists ADD FOREIGN KEY (uid) REFERENCES users (id) ON DELETE CASCADE;
+
+-- regenerate vn.c_* columns
+SELECT COUNT(*) FROM (SELECT update_vncache(id) FROM vn WHERE NOT hidden) s;
+