From: | "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at> |
---|---|
To: | pgsql-sql <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Re: [SQL] Permission problem with COPY FROM |
Date: | 1999-09-15 16:14:10 |
Message-ID: | 19990915181410.A10830@frithjof |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers 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(at)tph(dot)tuwien(dot)ac(dot)at>
---------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Wagner | 1999-09-15 16:26:04 | hard limit on result handles reached |
Previous Message | Tom Lane | 1999-09-15 14:00:02 | Re: [HACKERS] Permission problem with COPY FROM |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Dexter | 1999-09-15 16:20:58 | Comparison Suggestion |
Previous Message | Tom Lane | 1999-09-15 14:02:07 | Re: [HACKERS] Status report: long-query-string changes |
From | Date | Subject | |
---|---|---|---|
Next Message | Stéphane FILLON | 1999-09-15 16:17:27 | CREATE FUNCTION |
Previous Message | Tom Lane | 1999-09-15 14:34:57 |