Re: Error with pg_dump (of data), with --role

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Error with pg_dump (of data), with --role
Дата
Msg-id 17C9259A-500D-44AB-9290-0CB1ED81A34E@gmail.com
обсуждение исходный текст
Ответ на Re: Error with pg_dump (of data), with --role  (Ken Tanzer <ken.tanzer@gmail.com>)
Список pgsql-general
Дерево обсуждения


On Feb 18, 2021, at 8:00 PM, Ken Tanzer <ken.tanzer@gmail.com> wrote:




On Thu, Feb 18, 2021 at 5:23 PM Rob Sargent <robjsargent@gmail.com> wrote:

>
> There is only one schema, public.
>
>

I suspect it is because "set role" doesn't "set search_path"


I'm not sure what you mean or are suggesting by that.  Is there something I'm supposed to do to set the search path?  Is that a known bug in pg_dump?  Something else?  As mentioned, there is only one schema....  

--
Do you need to set role at all? 
Can you put the function in “public”?

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

Предыдущее
От: Ken Tanzer
Дата:
Сообщение: Re: Error with pg_dump (of data), with --role
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error with pg_dump (of data), with --role