Re: Sometimes pg_dump generates dump which is not restorable - Mailing list pgsql-hackers

"Dmitry Koterov" <dmitry@koterov.ru> 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