From 73b6c4c96798fe6b6c49b65c82f3e3fa396317b1 Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Tue, 30 Nov 2010 15:28:42 +0200 Subject: [PATCH] londiste.drop_table_triggers: check whether trigger has args --- sql/londiste/functions/londiste.drop_table_triggers.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/sql/londiste/functions/londiste.drop_table_triggers.sql b/sql/londiste/functions/londiste.drop_table_triggers.sql index 3e1958b2..9e085c7c 100644 --- a/sql/londiste/functions/londiste.drop_table_triggers.sql +++ b/sql/londiste/functions/londiste.drop_table_triggers.sql @@ -34,6 +34,7 @@ begin select tgname from pg_catalog.pg_trigger where tgrelid = londiste.find_table_oid(i_table_name) and londiste.is_replica_func(tgfoid) + and octet_length(tgargs) > 0 and substring(tgargs for (position(E'\\000'::bytea in tgargs) - 1)) = b_queue_name loop execute 'drop trigger ' || quote_ident(logtrg_name) -- 2.39.5