Re: feature proposal ... - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: feature proposal ...
Date
Msg-id 200509221601.j8MG1a422528@candle.pha.pa.us
Whole thread Raw
In response to Re: feature proposal ...  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Added to TODO:
       o Allow COPY to output from views

---------------------------------------------------------------------------

Andrew Dunstan wrote:
> 
> 
> Rod Taylor wrote:
> 
> >On Wed, 2005-09-21 at 15:25 -0700, Trent Shipley wrote:
> >  
> >
> >>
> >>Wouldn't you also need a CREATE TEMP TABLE privilege but the 
> >>COPY TO file USING select_statement
> >>would only need select.  (In other words using a temp table would not seem to 
> >>be as secure nor as general as the requested feature.)
> >>    
> >>
> >
> >Writing a file on the server requires significant privilege, including
> >access to the server itself so you can retrieve the results.
> >  
> >
> 
> But we also do COPY to STDOUT which requires no special privileges on 
> the server.
> 
> Incidentally, if we are going to allow copy out from views, it would be 
> nice and orthogonal to allow copy in too. Hasn't there been some talk 
> about making automatically writeable views?
> 
> cheers
> 
> andrew
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Hierarchical Queries--Stalled No Longer...
Next
From: Simon Riggs
Date:
Subject: Re: Why does VACUUM FULL bother locking pages?