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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
