Received: from frithjof.reiner (qmailr@a111.dialin.tuwien.ac.at [192.35.240.121]) by hub.org (8.9.3/8.9.3) with SMTP id MAA98661 for ; Wed, 15 Sep 1999 12:14:16 -0400 (EDT) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 10861 invoked by uid 500); 15 Sep 1999 16:14:11 -0000 From: "Albert REINER" Date: Wed, 15 Sep 1999 18:14:10 +0200 To: pgsql-sql Subject: Re: [SQL] Permission problem with COPY FROM Message-ID: <19990915181410.A10830@frithjof> Mail-Followup-To: pgsql-sql References: <000e01befedd$3e2210c0$a6373ad1@portable> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-3 Content-Transfer-Encoding: 8bit X-Mailer: Mutt 0.95.6i In-Reply-To: =?iso-8859-3?Q?=3C000e01befedd$3e2210c0$a6373ad1=40portable=3E=3B_from_S?= =?iso-8859-3?Q?t=E9phane_FILLON_on_Wed=2C_Sep_15=2C_1999_at_03:50:09AM_+?= =?iso-8859-3?Q?1100?= On Wed, Sep 15, 1999 at 03:50:09AM +1100, Stéphane FILLON wrote: ... > > "ERROR: COPY command, running in backend with effective uid 501 > (that's Postgres), could not open file '/usr/local/.../cltclr001' for > reading. Error: Permission not allowed (13)." > The problem does not seem to be with the permissions --- it has been on the list a number of times already. Try using psql's \copy instead. Albert. -- --------------------------------------------------------------------------- Post an / Mail to / Skribu al: Albert Reiner ---------------------------------------------------------------------------