From 3b545f8a39f3de71d2e6d1ffed3fc62a1adc323f Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Mon, 20 Jul 2009 01:42:24 +0000 Subject: [PATCH] For oldimage table, do ON UPDATE CASCADE. Per bug #19445. Note: still needs adjustments to updaters.inc --- maintenance/postgres/tables.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index a8e423768c..8c36f94aa4 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -288,7 +288,7 @@ CREATE TABLE oldimage ( oi_deleted SMALLINT NOT NULL DEFAULT 0, oi_sha1 TEXT NOT NULL DEFAULT '' ); -ALTER TABLE oldimage ADD CONSTRAINT oldimage_oi_name_fkey_cascade FOREIGN KEY (oi_name) REFERENCES image(img_name) ON DELETE CASCADE; +ALTER TABLE oldimage ADD CONSTRAINT oldimage_oi_name_fkey_cascade FOREIGN KEY (oi_name) REFERENCES image(img_name) ON DELETE CASCADE ON UPDATE CASCADE; CREATE INDEX oi_name_timestamp ON oldimage (oi_name,oi_timestamp); CREATE INDEX oi_name_archive_name ON oldimage (oi_name,oi_archive_name); CREATE INDEX oi_sha1 ON oldimage (oi_sha1); -- 2.20.1