From: | "Sampath, Krishna" <KSampath(at)ekmail(dot)com> |
---|---|
To: | Adam Ruth <aruth(at)intercation(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | RE: Permission denied while importing data from a file? |
Date: | 2000-04-10 15:17:11 |
Message-ID: | EDD4714513C8D2118B940090273D1A8201183B3A@NJ01SNT11 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
maybe the directory '.../somebody' does not have read permission (700?)
krishna
-----Original Message-----
From: Adam Ruth [mailto:aruth(at)intercation(dot)com]
Sent: Monday, April 10, 2000 9:54 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Permission denied while importing data from a
file?
I've gotten that message before when users couldn't read the directory the
file is in.
--
Adam Ruth
InterCation, Inc.
www.intercation.com
"Felix Slager" <slager(at)hydra(dot)accu(dot)uu(dot)nl> wrote in message
news:38F0ACDC(dot)CBCE5538(at)hydra(dot)accu(dot)uu(dot)nl(dot)(dot)(dot)
> LS,
>
> i'm trying to copy data into a table using a copy command using:
>
> COPY tabelName FROM '/somewhere/somebody/datafile.txt';
>
> I've given everybody the right to use the datafile.txt (execute, read,
> write) with an incredible chmod 7777. Still i get the message:
>
> ERROR: COPY command, running in backend with effective uid nr 666,
> could not open file '/somewhere/somebody/datafile.txt' for reading.
> Errno = Permission denied (13).
>
> Why? I mean how does this happen?
> Please help...
>
> Felix
From | Date | Subject | |
---|---|---|---|
Next Message | Sampath, Krishna | 2000-04-10 15:39:18 | RE: BLOB datatype |
Previous Message | Ed Loehr | 2000-04-10 14:25:32 | Re: need a help |