Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-11-16 Thread dinesh kumar
On Tue, Nov 17, 2015 at 1:02 AM, Michael Paquier wrote: > On Mon, Nov 16, 2015 at 11:27 AM, Michael Paquier wrote: > > In short, it seems that this patch is better rejected. And I am > > planning to do so if there are no complaints. > > OK, done so in the CF app. > Dinesh, please do not be discou

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-11-16 Thread Michael Paquier
On Mon, Nov 16, 2015 at 11:27 AM, Michael Paquier wrote: > In short, it seems that this patch is better rejected. And I am > planning to do so if there are no complaints. OK, done so in the CF app. Dinesh, please do not be discouraged by that. Everybody has patches rejected, and I know a bit of it

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-11-15 Thread Michael Paquier
On Mon, Nov 16, 2015 at 11:05 AM, Peter Eisentraut wrote: > On 9/2/15 4:19 PM, Stefan Kaltenbrunner wrote: >> maybe - but having a fixed "default" is very different from baking a >> classic unix permission concept of user/group/world^others into actual >> DDL or into a COPY option. The proposed s

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-11-15 Thread Peter Eisentraut
On 9/2/15 4:19 PM, Stefan Kaltenbrunner wrote: > maybe - but having a fixed "default" is very different from baking a > classic unix permission concept of user/group/world^others into actual > DDL or into a COPY option. The proposed syntax might make some sense to > a admin used to a unix style sy

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-11-12 Thread dinesh kumar
On Thu, Nov 12, 2015 at 4:35 AM, Michael Paquier wrote: > On Sat, Oct 3, 2015 at 1:43 PM, dinesh kumar wrote: > > We can also use "PROGRAM 'cat > Output.csv' " to achieve this "NO READ > > ACCESS", since the program is always running as a instance owner. > > Let me know your inputs and thoughts.

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-11-12 Thread Michael Paquier
On Sat, Oct 3, 2015 at 1:43 PM, dinesh kumar wrote: > We can also use "PROGRAM 'cat > Output.csv' " to achieve this "NO READ > ACCESS", since the program is always running as a instance owner. > Let me know your inputs and thoughts. That's one way. And as PROGRAM presents the advantage to open the

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-10-02 Thread dinesh kumar
On Wed, Sep 2, 2015 at 1:19 PM, Stefan Kaltenbrunner < ste...@kaltenbrunner.cc> wrote: > On 09/02/2015 10:10 PM, dinesh kumar wrote: > > On Tue, Sep 1, 2015 at 10:58 PM, Stefan Kaltenbrunner > > mailto:ste...@kaltenbrunner.cc>> wrote: > > > > On 07/25/2015 03:38 AM, dinesh kumar wrote: > >

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-09-02 Thread Stefan Kaltenbrunner
On 09/02/2015 10:10 PM, dinesh kumar wrote: > On Tue, Sep 1, 2015 at 10:58 PM, Stefan Kaltenbrunner > mailto:ste...@kaltenbrunner.cc>> wrote: > > On 07/25/2015 03:38 AM, dinesh kumar wrote: > > > > > > On Fri, Jul 24, 2015 at 10:22 AM, Robert Haas >

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-09-02 Thread dinesh kumar
On Tue, Sep 1, 2015 at 10:58 PM, Stefan Kaltenbrunner < ste...@kaltenbrunner.cc> wrote: > On 07/25/2015 03:38 AM, dinesh kumar wrote: > > > > > > On Fri, Jul 24, 2015 at 10:22 AM, Robert Haas > > wrote: > > > > On Thu, Jul 23, 2015 at 8:15 PM, dinesh kumar > >

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-09-01 Thread Stefan Kaltenbrunner
On 07/25/2015 03:38 AM, dinesh kumar wrote: > > > On Fri, Jul 24, 2015 at 10:22 AM, Robert Haas > wrote: > > On Thu, Jul 23, 2015 at 8:15 PM, dinesh kumar > mailto:dineshkuma...@gmail.com>> wrote: > > On Thu, Jul 23, 2015 at 9:21 AM, Robert Haas > m

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-24 Thread dinesh kumar
On Fri, Jul 24, 2015 at 10:22 AM, Robert Haas wrote: > On Thu, Jul 23, 2015 at 8:15 PM, dinesh kumar > wrote: > > On Thu, Jul 23, 2015 at 9:21 AM, Robert Haas > wrote: > >> > >> On Thu, Jul 23, 2015 at 12:19 PM, dinesh kumar > > >> wrote: > >> > Sorry for my unclear description about the prop

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-24 Thread Robert Haas
On Thu, Jul 23, 2015 at 8:15 PM, dinesh kumar wrote: > On Thu, Jul 23, 2015 at 9:21 AM, Robert Haas wrote: >> >> On Thu, Jul 23, 2015 at 12:19 PM, dinesh kumar >> wrote: >> > Sorry for my unclear description about the proposal. >> > >> > "WITH PERMISSIVE" is equal to our existing behavior. That

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-23 Thread dinesh kumar
On Thu, Jul 23, 2015 at 9:21 AM, Robert Haas wrote: > On Thu, Jul 23, 2015 at 12:19 PM, dinesh kumar > 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'

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-23 Thread Robert Haas
On Thu, Jul 23, 2015 at 12:19 PM, dinesh kumar 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 fil

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-23 Thread dinesh kumar
Hi Robert/Andres, On Thu, Jul 23, 2015 at 8:34 AM, Robert Haas wrote: > On Thu, Jul 23, 2015 at 11:32 AM, Andres Freund > wrote: > > On 2015-07-23 11:26:27 -0400, Robert Haas wrote: > >> On Wed, Jul 22, 2015 at 11:29 PM, dinesh kumar > wrote: > >> > Would like to propose PERMISSIVE mode for th

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-23 Thread Robert Haas
On Thu, Jul 23, 2015 at 11:32 AM, Andres Freund wrote: > On 2015-07-23 11:26:27 -0400, Robert Haas wrote: >> On Wed, Jul 22, 2015 at 11:29 PM, dinesh kumar >> wrote: >> > Would like to propose PERMISSIVE mode for the COPY created out files. >> > I mean, at this moment, if do "COPY" as postgres i

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-23 Thread Andres Freund
On 2015-07-23 11:26:27 -0400, Robert Haas wrote: > On Wed, Jul 22, 2015 at 11:29 PM, dinesh kumar > 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

Re: [HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-23 Thread Robert Haas
On Wed, Jul 22, 2015 at 11:29 PM, dinesh kumar 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 > instan

[HACKERS] Proposing COPY .. WITH PERMISSIVE

2015-07-22 Thread dinesh kumar
Hi All, 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 thoug