"Dmitry Koterov" <[EMAIL PROTECTED]> writes:
> 3. The function a() calls any OTHER function b() from OTHER namespace (or
> uses operators from other namespaces), but does not specify the schema name,
> because it is in database search_path:
> CREATE FUNCTION a(i integer) RETURNS boolean AS $$
> BEGIN
> PERFORM b(); -- b() is is from "nsp" schema
> RETURN true;
> END;$$ LANGUAGE plpgsql IMMUTABLE;
I think your function is broken. You might want to fix it by attaching
a local search_path setting to it.
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
