Re: COPY from question

Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au> writes:
> ... I get the following error on Linux
> machine even if permissions on the data file are 777:

>   _pg.error: ERROR:  COPY command, running in backend with effective uid
>   26, could not open file '/home/slavisa/.nimrod/experiments/demo/ejdata'
>   for reading.  Errno = Permission denied (13).

Most likely the postgres user doesn't have read permission for one of
the directories in that path.

			regards, tom lane

PS: this didn't really belong on pghackers.