Re: COPY access rights

On Tue, May 14, 2002 at 02:39:19PM -0400,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> > The 7.2.1 documentation says that either insert or update access is needed
> > to use COPY FROM. However under GRANT the INSERT description says it
> > gives access to COPY FROM, but the UPDATE description doesn't.
>
> The code wants INSERT and nothing but, which seems correct to me since
> COPY FROM is effectively a series of INSERTs. IIRC it used to accept
> UPDATE too; I suspect someone missed this statement in the documentation
> when we changed it.
>
> I see the erroneous statement on the COPY reference page; did you notice
> it anywhere else?

I just saw it on the COPY command reference part of the SQL COMMANDS
section of the documentation.

>
> Now that I look, the GRANT page is confused too: COPY FROM is FROM a
> file, not FROM a table. Will fix.

That was my mistake. It does say COPY TO for insert.

>
> regards, tom lane