Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 7B77C475C37 for ; Tue, 14 May 2002 16:19:42 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 77D81475EE5 for ; Tue, 14 May 2002 14:39:20 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g4EIdJW29865; Tue, 14 May 2002 14:39:20 -0400 (EDT) To: Bruno Wolff III Cc: pgsql-docs@postgresql.org Subject: Re: COPY access rights In-reply-to: <20020514155859.GA2361@wolff.to> References: <20020514155859.GA2361@wolff.to> Comments: In-reply-to Bruno Wolff III message dated "Tue, 14 May 2002 10:58:59 -0500" Date: Tue, 14 May 2002 14:39:19 -0400 Message-ID: <29862.1021401559@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200205/9 X-Sequence-Number: 1367 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