From 202acccbbfebb4c0205a22feefcd7a94d1ee6a6b Mon Sep 17 00:00:00 2001 From: River Tarnell Date: Wed, 7 Mar 2007 22:17:43 +0000 Subject: [PATCH] ERROR: syntax error at or near "a2" at character 22 LINE 1: DELETE FROM archive2 a2 WHERE a2.ar_title = OLD.ar_title AN... --- maintenance/postgres/tables.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 868bc5c072..2ed27ef430 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -153,10 +153,10 @@ DO INSTEAD INSERT INTO archive2 VALUES ( ); CREATE RULE archive_delete AS ON DELETE TO archive -DO INSTEAD DELETE FROM archive2 a2 WHERE - a2.ar_title = OLD.ar_title AND - a2.ar_namespace = OLD.ar_namespace AND - a2.ar_rev_id = OLD.ar_rev_id; +DO INSTEAD DELETE FROM archive2 WHERE + archive2.ar_title = OLD.ar_title AND + archive2.ar_namespace = OLD.ar_namespace AND + archive2.ar_rev_id = OLD.ar_rev_id; CREATE TABLE redirect ( -- 2.20.1