| 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: | Whole Thread | Raw Message | 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 |