Re: [SQL] Permission problem with COPY FROM - Mailing list pgsql-sql

From Albert REINER
Subject Re: [SQL] Permission problem with COPY FROM
Date
Msg-id 19990915181410.A10830@frithjof
Whole thread Raw
In response to Permission problem with COPY FROM  ("Stéphane FILLON" <fillons@offratel.nc>)
List pgsql-sql
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<areiner@tph.tuwien.ac.at>
 
---------------------------------------------------------------------------


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: ...
Next
From: "Stéphane FILLON"
Date:
Subject: CREATE FUNCTION