diff options
Diffstat (limited to 'util/updates/update_2.14.sql')
-rw-r--r-- | util/updates/update_2.14.sql | 8 |
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; + |