diff options
4 files changed, 4 insertions, 4 deletions
diff --git a/sql/londiste/functions/londiste.link.sql b/sql/londiste/functions/londiste.link.sql index befedf04..c9a7e09f 100644 --- a/sql/londiste/functions/londiste.link.sql +++ b/sql/londiste/functions/londiste.link.sql @@ -41,7 +41,7 @@ begin end loop; return list1 = list2; end; -$$ language plpgsql; +$$ language plpgsql security definer; create or replace function londiste.link(i_source_name text, i_dest_name text, prov_tick_id bigint, prov_tbl_list text, prov_seq_list text) returns text as $$ diff --git a/sql/londiste/functions/londiste.provider_add_table.sql b/sql/londiste/functions/londiste.provider_add_table.sql index 354b5572..1e14c39b 100644 --- a/sql/londiste/functions/londiste.provider_add_table.sql +++ b/sql/londiste/functions/londiste.provider_add_table.sql @@ -44,5 +44,5 @@ begin return londiste.provider_add_table(i_queue_name, i_table_name, londiste.find_column_types(i_table_name)); end; -$$ language plpgsql; +$$ language plpgsql security definer; diff --git a/sql/londiste/functions/londiste.provider_notify_change.sql b/sql/londiste/functions/londiste.provider_notify_change.sql index 65505fb0..2b6576eb 100644 --- a/sql/londiste/functions/londiste.provider_notify_change.sql +++ b/sql/londiste/functions/londiste.provider_notify_change.sql @@ -22,5 +22,5 @@ begin return 1; end; -$$ language plpgsql; +$$ language plpgsql security definer; diff --git a/sql/londiste/functions/londiste.subscriber_remove_table.sql b/sql/londiste/functions/londiste.subscriber_remove_table.sql index 49af4053..23f21246 100644 --- a/sql/londiste/functions/londiste.subscriber_remove_table.sql +++ b/sql/londiste/functions/londiste.subscriber_remove_table.sql @@ -23,5 +23,5 @@ begin return 0; end; -$$ language plpgsql; +$$ language plpgsql security definer; |