summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormartinko2013-12-06 08:53:46 +0000
committermartinko2013-12-06 08:53:46 +0000
commit361c4f6d2da5cc575e07448c7c7b16df7f6a452f (patch)
treeec93b7a9e9c33fbc927282cd97365a02ebe76158 /sql
parentb18e10987e59691df4cb33499d64b5e03ce37a6d (diff)
fixed londiste.table_info trigger issue
Diffstat (limited to 'sql')
-rw-r--r--sql/londiste/functions/londiste.table_info_trigger.sql2
-rw-r--r--sql/londiste/structure/triggers.sql2
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();