COPY access rights
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.
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
The team of translation to spanish for the documentation of PostgreSQL
is happy to annonce the publication of the alfa version for the spanish
version of the official documentation.
This translation is about the 6.5.3 version, it's true, but we are
already working in 7.1.2 (13 % done now).
We'll happy to recibe comments, sugestions, ...
Best regard.
Eduardo Maldonado doc-postgresql-es@listas.hispalinux.es
Coordinator
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
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.
Show quoted text
regards, tom lane