diff options
author | Yorhel <git@yorhel.nl> | 2010-11-28 10:53:36 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-11-28 10:53:36 +0100 |
commit | a783da4a62350f3190563d75c3e8238ae25bb4f5 (patch) | |
tree | ce9da2274424bee05249fa47a79642a5f146f62a | |
parent | e27071f4110c6a93ef140b2d3dde331194917616 (diff) |
BUGFIX: Moved update_vncache() to the bottom of the update script2.14
Otherwise it'd send out a lot of "entry has been deleted" notifications.
>.>
-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; + |