Re: Proposing COPY .. WITH PERMISSIVE - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Proposing COPY .. WITH PERMISSIVE
Date
Msg-id CA+Tgmobbw3OfzdtNf=TzP6-FiQgn+T7gG9T+rTeDByvwVFKPSQ@mail.gmail.com
Whole thread Raw
In response to Re: Proposing COPY .. WITH PERMISSIVE  (Andres Freund <andres@anarazel.de>)
Responses Re: Proposing COPY .. WITH PERMISSIVE  (dinesh kumar <dineshkumar02@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Autonomous Transaction is back
Next
From: Robert Haas
Date:
Subject: Re: proposal: multiple psql option -c