pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedCOPY access rights
3+ messages / 2 participants
[nested] [flat]
* COPY access rights
@ 2002-05-14 15:58 Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 3+ messages in thread
From: Bruno Wolff III @ 2002-05-14 15:58 UTC (permalink / raw)
To: pgsql-docs
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.
Since it doesn't look like you could really use COPY FROM to do updates,
I am guessing that the information under COPY is incorrect.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: COPY access rights
@ 2002-05-14 18:39 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2002-05-14 18:39 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-docs
Bruno Wolff III <bruno@wolff.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?
Now that I look, the GRANT page is confused too: COPY FROM is FROM a
file, not FROM a table. Will fix.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: COPY access rights
@ 2002-05-14 23:51 Bruno Wolff III <bruno@wolff.to>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Bruno Wolff III @ 2002-05-14 23:51 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs
On Tue, May 14, 2002 at 02:39:19PM -0400,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Bruno Wolff III <bruno@wolff.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-05-14 23:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-05-14 15:58 COPY access rights Bruno Wolff III <bruno@wolff.to>
2002-05-14 18:39 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-05-14 23:51 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox