Postgres Pro
Downloads
Home   >   mailing lists

Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program - Mailing list pgsql-general

From Chema
Subject Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Date
Msg-id CALdEsqPZTQFEtBsn2XB4dYuTQ6V4Uj65rrwk3ibqy3eDP59ivQ@mail.gmail.com
Whole thread Raw
In response to 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>)
List pgsql-general
Tree view

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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
Next
From: Chandy G
Date:
Subject: Re: postgres table statistics