From d8863d7a474bcf0f19f18969af57c1ba5bec38cf Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Wed, 8 Jul 2009 18:01:11 +0300 Subject: [PATCH] londiste: fix missing END IF and some ws in local_add_table() --- sql/londiste/functions/londiste.local_add_table.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/sql/londiste/functions/londiste.local_add_table.sql b/sql/londiste/functions/londiste.local_add_table.sql index 50d77e15..ad5017b4 100644 --- a/sql/londiste/functions/londiste.local_add_table.sql +++ b/sql/londiste/functions/londiste.local_add_table.sql @@ -116,17 +116,18 @@ begin into logtrg_previous from pg_catalog.pg_trigger where tgrelid = londiste.find_table_oid(fq_table_name) - and not tgisconstraint + and not tgisconstraint and substring(tgname from 1 for 10) != '_londiste_' and tgname < logtrg_name; if found then - select 301, + select 301, 'Table added: ' || fq_table_name || ', but londiste trigger is not first: ' || logtrg_previous into ret_code, ret_note; - return; + return; + end if; select 200, 'Table added: ' || fq_table_name into ret_code, ret_note; return; -- 2.39.5