Re: Proposing COPY .. WITH PERMISSIVE

On Thu, Jul 23, 2015 at 11:32 AM, Andres Freund <andres@anarazel.de> wrote:
> On 2015-07-23 11:26:27 -0400, Robert Haas wrote:
>> On Wed, Jul 22, 2015 at 11:29 PM, dinesh kumar <dineshkumar02@gmail.com> wrote:
>> > Would like to propose PERMISSIVE mode for the COPY created out files.
>> > I mean, at this moment, if do "COPY" as postgres instance owner, i can able
>> > to read the file as non instance user as well, and would like to restrict
>> > this to
>> > instance owner WITH PERMISSIVE option.
>> >
>> > Let me know your thoughts on this.
>>
>> I don't understand the proposal.
>
> I understand it as PERMISSIVE := chmod 777 the target file of a COPY TO.

That doesn't sound like an especially good idea.  What if I want mode 770?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company