From 578419e551de58db6e15d18eb1eae1cdb51bc8e5 Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Tue, 12 Oct 2010 16:26:04 +0300 Subject: [PATCH] londiste: "on delete cascade" fkeys for tables this avoids need to write cleanup code --- sql/londiste/structure/tables.sql | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) diff --git a/sql/londiste/structure/tables.sql b/sql/londiste/structure/tables.sql index d5e5142e..020acaa6 100644 --- a/sql/londiste/structure/tables.sql +++ b/sql/londiste/structure/tables.sql @@ -96,7 +96,9 @@ create table londiste.table_info ( table_attrs text, primary key (queue_name, table_name), - foreign key (queue_name) references pgq_node.node_info (queue_name), + foreign key (queue_name) + references pgq_node.node_info (queue_name) + on delete cascade, check (dropped_ddl is null or merge_state = 'in-copy') ); @@ -121,7 +123,9 @@ create table londiste.seq_info ( last_value int8 not null, primary key (queue_name, seq_name), - foreign key (queue_name) references pgq_node.node_info (queue_name) + foreign key (queue_name) + references pgq_node.node_info (queue_name) + on delete cascade ); @@ -141,7 +145,10 @@ create table londiste.applied_execute ( execute_file text not null, execute_time timestamptz not null default now(), execute_sql text not null, - primary key (queue_name, execute_file) + primary key (queue_name, execute_file), + foreign key (queue_name) + references pgq_node.node_info (queue_name) + on delete cascade ); -- 2.39.5