Thread: Question about COPY command

Question about COPY command

From
Mercury He
Date:
I tried the import some text file to PostgreSQL database with COPY
command.
But I got this message:
ERROR:  COPY command, running in backend with
effective uid 100, could not open.

What's wrong with it?




Re: [SQL] Question about COPY command

From
Christopher Sawtell
Date:
On Mon, 24 Jan 2000, Mercury He wrote:
> I tried the import some text file to PostgreSQL database with COPY
> command.
> But I got this message:
> ERROR:  COPY command, running in backend with
> effective uid 100, could not open.
> 
> What's wrong with it?

Permissions on the text file prevent it being read by the backend process.
( uid100 ) Make it world readable.

--
Sincerely etc.,
NAME       Christopher Sawtell - Support Engineer - iOpen Technologies Ltd.CELL PHONE 021 257 4451ICQ UIN
45863470EMAIL     chris @ iopen . co . nz,  csawtell @ xtra . co . nzCNOTES
ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
---->>> Please refrain from using HTML attachments in e-mails to me. <<<----