COPY access rights

Поиск
Список
Период
Сортировка
Искать

COPY access rights

От:
Bruno Wolff III <bruno@wolff.to>
Дата:
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.

Re: COPY access rights

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Bruno Wolff III  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

Re: COPY access rights

От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Tue, May 14, 2002 at 02:39:19PM -0400,
  Tom Lane  wrote:
> Bruno Wolff III  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

Official Documentation in Spanish

От:
Eduardo Maldonado <emaldonadog@yahoo.es>
Дата:
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

FAQ