Re: Sometimes pg_dump generates dump which is not restorable

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Sometimes pg_dump generates dump which is not restorable
Дата
Msg-id 19458.1226599664@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Sometimes pg_dump generates dump which is not restorable  ("Dmitry Koterov" <dmitry@koterov.ru>)
Ответы Re: Sometimes pg_dump generates dump which is not restorable  ("Dmitry Koterov" <dmitry@koterov.ru>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Simple postgresql.conf wizard
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Simple postgresql.conf wizard