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

From Robert Haas
Subject Re: Proposing COPY .. WITH PERMISSIVE
Date
Msg-id CA+TgmoYYLUuoVV5EF9xdYo6SosngJ7zk2nBN1v=uCCfgVL9zpQ@mail.gmail.com
Whole thread Raw
In response to Re: Proposing COPY .. WITH PERMISSIVE  (dinesh kumar <dineshkumar02@gmail.com>)
Responses Re: Proposing COPY .. WITH PERMISSIVE
List pgsql-hackers
On Thu, Jul 23, 2015 at 12:19 PM, dinesh kumar <dineshkumar02@gmail.com> wrote:
> Sorry for my  unclear description about the proposal.
>
> "WITH PERMISSIVE" is equal to our existing behavior. That is, chmod=644 on
> the created files.
>
> If User don't specify "PERMISSIVE" as an option, then the chmod=600 on
> created files. In this way, we can restrict the other users from reading
> these files.

There might be some benefit in allowing the user to choose the
permissions, but (1) I doubt we want to change the default behavior
and (2) providing only two options doesn't seem flexible enough.

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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgbench stats per script & other stuff
Next
From: Jeff Janes
Date:
Subject: Re: All-zero page in GIN index causes assertion failure