summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-11-28 10:53:36 +0100
committerYorhel <git@yorhel.nl>2010-11-28 10:53:36 +0100
commita783da4a62350f3190563d75c3e8238ae25bb4f5 (patch)
treece9da2274424bee05249fa47a79642a5f146f62a
parente27071f4110c6a93ef140b2d3dde331194917616 (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.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;
+