pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question about COPY command
2+ messages / 2 participants
[nested] [flat]

* Question about COPY command
@ 2000-01-24 04:11 Mercury He <mercury@penit.com>
  2000-01-24 10:48 ` Re: [SQL] Question about COPY command Christopher Sawtell <csawtell@xtra.co.nz>
  0 siblings, 1 reply; 2+ messages in thread

From: Mercury He @ 2000-01-24 04:11 UTC (permalink / raw)
  To: pgsql-sql


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?





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Question about COPY command
  2000-01-24 04:11 Question about COPY command Mercury He <mercury@penit.com>
@ 2000-01-24 10:48 ` Christopher Sawtell <csawtell@xtra.co.nz>
  0 siblings, 0 replies; 2+ messages in thread

From: Christopher Sawtell @ 2000-01-24 10:48 UTC (permalink / raw)
  To: mercury@penit.com, Mercury He <mercury@penit.com>; pgsql-sql

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 4451
 ICQ UIN    45863470
 EMAIL      chris @ iopen . co . nz,  csawtell @ xtra . co . nz
 CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 ---->>> Please refrain from using HTML attachments in e-mails to me. <<<----




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-01-24 10:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-24 04:11 Question about COPY command Mercury He <mercury@penit.com>
2000-01-24 10:48 ` Christopher Sawtell <csawtell@xtra.co.nz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox