diff options
| author | martinko | 2013-12-06 08:53:46 +0000 |
|---|---|---|
| committer | martinko | 2013-12-06 08:53:46 +0000 |
| commit | 361c4f6d2da5cc575e07448c7c7b16df7f6a452f (patch) | |
| tree | ec93b7a9e9c33fbc927282cd97365a02ebe76158 /sql | |
| parent | b18e10987e59691df4cb33499d64b5e03ce37a6d (diff) | |
fixed londiste.table_info trigger issue
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/londiste/functions/londiste.table_info_trigger.sql | 2 | ||||
| -rw-r--r-- | 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(); |
