| From: | Christopher Sawtell <csawtell(at)xtra(dot)co(dot)nz> |
|---|---|
| To: | mercury(at)penit(dot)com, Mercury He <mercury(at)penit(dot)com>, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] Question about COPY command |
| Date: | 2000-01-24 10:48:57 |
| Message-ID: | 00012423512800.00577@berty |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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. <<<----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathijs Brands | 2000-01-24 15:54:39 | Re: [SQL] Blobs |
| Previous Message | Patrik Kudo | 2000-01-24 10:00:57 | Re: [SQL] Duplicate tuples with unique index |