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. <<<----