diff options
Diffstat (limited to 'maintenance/postgres/archives/patch-archive_delete.sql')
-rw-r--r-- | maintenance/postgres/archives/patch-archive_delete.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/maintenance/postgres/archives/patch-archive_delete.sql b/maintenance/postgres/archives/patch-archive_delete.sql new file mode 100644 index 00000000..4a864c3b --- /dev/null +++ b/maintenance/postgres/archives/patch-archive_delete.sql @@ -0,0 +1,5 @@ +CREATE RULE archive_delete AS ON DELETE TO archive +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; |