summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-10-24 11:41:51 +0200
committerYorhel <git@yorhel.nl>2009-10-24 11:41:51 +0200
commitb4bef02c08a3bc8198f97d0e97701981f9bb85c8 (patch)
tree55229b0059cf56d8f00428844416d8b8f74a1ce9 /util/dump.sql
parent56e691ac21163519392bb1711d173f4b52c24470 (diff)
Removed update_rev() function and monthly revcache cron
The changes.rev column should be correct in the first place, and in the (most likely) impossible condition that it isn't, the update_rev() function is more likely to make things worse.
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql25
1 files changed, 0 insertions, 25 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 9f8710f8..0fdf5696 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -420,31 +420,6 @@ ALTER TABLE wlists ADD FOREIGN KEY (vid) REFERENCES vn
-------------------------
--- update_rev(table, ids) - updates the rev column in the changes table
-CREATE FUNCTION update_rev(tbl text, ids text) RETURNS void AS $$
-DECLARE
- r RECORD;
- r2 RECORD;
- i integer;
- t text;
- e text;
-BEGIN
- SELECT INTO t SUBSTRING(tbl, 1, 1);
- e := '';
- IF ids <> '' THEN
- e := ' WHERE id IN('||ids||')';
- END IF;
- FOR r IN EXECUTE 'SELECT id FROM '||tbl||e LOOP
- i := 1;
- FOR r2 IN EXECUTE 'SELECT id FROM '||tbl||'_rev WHERE '||t||'id = '||r.id||' ORDER BY id ASC' LOOP
- UPDATE changes SET rev = i WHERE id = r2.id;
- i := i+1;
- END LOOP;
- END LOOP;
-END;
-$$ LANGUAGE plpgsql;
-
-
-- update_vncache(id) - updates the c_* columns in the vn table
CREATE FUNCTION update_vncache(id integer) RETURNS void AS $$
DECLARE