RE: [GENERAL] Permission denied while importing data from a file?
maybe the directory '.../somebody' does not have read permission (700?) krishna -Original Message- From: Adam Ruth [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 9:54 AM To: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 . 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
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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 . 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
Re: [GENERAL] Permission denied while importing data from a file?
Try moving the file into /tmp and seeing if that works. Sometimes you run into problems with having permissiosn on the file, but not all of the directories before it. You must have execute permissions on all parent directories in order to access a file in one of those dirs. The file will only need read access (444), although the others won't stop it from working (it will just be less secure if you are on a multi-user system.) Also, I believe that one of the copy commands (either \copy or the COPY SQL command) can only be done as the database super user (postgres or pgsql, depending on how you installed Postgres) Maybe you are using the wrong one? At 01:16 PM 4/9/00, you wrote: >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 . 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
[GENERAL] Permission denied while importing data from a file?
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 . 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