On 07/11/11 14:43, Ivan Sergio Borgonovo wrote:
>
> create or replace function test_insert() returns void as
[snip]
> $$ language plpgsql volatile;
>
> set search_path to 'test1', 'public';
> set search_path to 'test2', 'public';
[snip unexpected behaviour]
I now try to add a SET search_path to the bottom of all my plpgsql
functions. It can get very confusing otherwise, as you've just demonstrated.
--
Richard Huxton
Archonet Ltd