pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion 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