Re: pg_dump and search_path

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: pg_dump and search_path
Дата
Msg-id 94e28e8c-e5cf-f0b5-a148-43452446d9ec@aklaver.com
обсуждение исходный текст
Ответ на pg_dump and search_path  ("Igal @ Lucee.org" <igal@lucee.org>)
Ответы Re: pg_dump and search_path  ("Igal @ Lucee.org" <igal@lucee.org>)
Список pgsql-general
On 7/8/19 11:48 PM, Igal @ Lucee.org wrote:
> I have a custom search_path:
> 
> # show search_path;
>             search_path
> ----------------------------------
>   "staging, transient, pg_catalog"
> (1 row)
> 
> I ran `pg_dump --schema-only` and the only reference in the output to 
> search_path is:
> 
>    SELECT pg_catalog.set_config('search_path', '', false);
> 
> Then one of my functions which does not reference the full name of a 
> table with its schema fails with "relation [rel-name] does not exist".

Where is this failing?

Do you have the search_path set in the config for the server you are 
dumping to?

> 
> Is that a bug?  I have seen some old posts about this issue but am not 
> sure if there is a ticket or why it still is an issue.
> 
> Thanks,
> 
> Igal Sapir
> Lucee Core Developer
> Lucee.org <http://lucee.org/>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



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

Предыдущее
От: Dave Hughes
Дата:
Сообщение: Re: SuperUser permission denied when creating table.
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: SuperUser permission denied when creating table.