From 361c4f6d2da5cc575e07448c7c7b16df7f6a452f Mon Sep 17 00:00:00 2001 From: martinko Date: Fri, 6 Dec 2013 09:53:46 +0100 Subject: [PATCH] fixed londiste.table_info trigger issue --- sql/londiste/functions/londiste.table_info_trigger.sql | 2 +- sql/londiste/structure/triggers.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/londiste/functions/londiste.table_info_trigger.sql b/sql/londiste/functions/londiste.table_info_trigger.sql index 1a225209..302ac35c 100644 --- a/sql/londiste/functions/londiste.table_info_trigger.sql +++ b/sql/londiste/functions/londiste.table_info_trigger.sql @@ -11,7 +11,7 @@ begin if TG_OP = 'DELETE' then perform londiste.drop_table_triggers(OLD.queue_name, OLD.table_name); end if; - return null; + return OLD; end; $$ language plpgsql; diff --git a/sql/londiste/structure/triggers.sql b/sql/londiste/structure/triggers.sql index ad75359d..3b35a4ad 100644 --- a/sql/londiste/structure/triggers.sql +++ b/sql/londiste/structure/triggers.sql @@ -1,4 +1,4 @@ -create trigger table_info_trigger_sync after delete on londiste.table_info +create trigger table_info_trigger_sync before delete on londiste.table_info for each row execute procedure londiste.table_info_trigger(); -- 2.39.5