From 3d4d36d1d369cbe882699120ff0445edee4f6a47 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 7 Feb 2007 16:06:08 +0000 Subject: [PATCH] Fix Postgres archive rule definition. --- maintenance/updaters.inc | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index aed6d7780c..54ae702736 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1207,6 +1207,14 @@ ALTER TABLE page_restrictions ADD CONSTRAINT page_restrictions_pk PRIMARY KEY (p -- Add a new index to help with full-text searches CREATE INDEX rev_text_id_idx ON revision (rev_text_id); +-- Fix the archive rule +CREATE OR REPLACE RULE archive_insert AS ON INSERT TO archive +DO INSTEAD INSERT INTO archive2 VALUES ( + NEW.ar_namespace, NEW.ar_title, NEW.ar_text, NEW.ar_comment, NEW.ar_user, NEW.ar_user_text, + TO_TIMESTAMP(NEW.ar_timestamp, 'YYYYMMDDHH24MISS'), + NEW.ar_minor_edit, NEW.ar_flags, NEW.ar_rev_id, NEW.ar_text_id +); + -- Note this upgrade INSERT INTO mediawiki_version (type,mw_version,notes) VALUES ('Upgrade','MWVERSION','Upgrade from older pre 1.10 version THISVERSION aka SVERSION'); -- 2.20.1