Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program

Поиск
Список
Период
Сортировка
От Chema
Тема Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Дата
Msg-id CALdEsqPZTQFEtBsn2XB4dYuTQ6V4Uj65rrwk3ibqy3eDP59ivQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения

Pretty sure since you choose not to allow justintestin to inherit stuff you will need to issue a “set role to pg_execute_server_program” before you attempt the copy command.

David J.

That was it!  Blind paranoia bites my rear again.  Thanks!

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Следующее
От: Chandy G
Дата:
Сообщение: Re: postgres table statistics