Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 87324475ABE for ; Tue, 14 May 2002 19:50:11 -0400 (EDT) Received: from wolff.to (wolff.to [66.92.219.49]) by postgresql.org (Postfix) with SMTP id 6927447594A for ; Tue, 14 May 2002 19:48:07 -0400 (EDT) Received: (qmail 11848 invoked by uid 500); 14 May 2002 23:51:36 -0000 Date: Tue, 14 May 2002 18:51:36 -0500 From: Bruno Wolff III To: Tom Lane Cc: pgsql-docs@postgresql.org Subject: Re: COPY access rights Message-ID: <20020514235136.GA11709@wolff.to> Mail-Followup-To: Tom Lane , pgsql-docs@postgresql.org References: <20020514155859.GA2361@wolff.to> <29862.1021401559@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <29862.1021401559@sss.pgh.pa.us> User-Agent: Mutt/1.3.25i X-Archive-Number: 200205/10 X-Sequence-Number: 1368 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