Re: COPY from question - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: COPY from question
Date
Msg-id Pine.LNX.4.33.0402022300080.8105-100000@leary.csoft.net
Whole thread Raw
In response to COPY from question  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
List pgsql-hackers

On Tue, 3 Feb 2004, Slavisa Garic wrote:

> My understanding is that COPY workes FROM 'filename' or STDIN where the
> last characters are '.\\n'. I tried using the copy from 'filename' and as
> I said NetBSD is not complaining where 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).
>

This is probably a permissions problem at a higher level, check the
permissions on the directories in the path.

Kris Jurka



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.5 change documentation
Next
From: Tom Lane
Date:
Subject: Re: COPY from question