Received: from mta1-rme.xtra.co.nz (mta1-rme.xtra.co.nz [203.96.92.1]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA35608 for ; Wed, 26 Jan 2000 02:11:41 -0500 (EST) (envelope-from csawtell@xtra.co.nz) Received: from berty ([210.55.87.9]) by mta1-rme.xtra.co.nz (InterMail v4.01.01.00 201-229-111) with SMTP id <20000126071903.BBQZ6460852.mta1-rme@berty>; Wed, 26 Jan 2000 20:19:03 +1300 From: Christopher Sawtell To: mercury@penit.com, Mercury He , pgsql-sql@postgreSQL.org Subject: Re: [SQL] Question about COPY command Date: Mon, 24 Jan 2000 23:48:57 +1300 X-Mailer: KMail [version 1.0.17] Content-Type: text/plain References: <388BD0E7.93B3C5E7@penit.com> MIME-Version: 1.0 Message-Id: <00012423512800.00577@berty> Content-Transfer-Encoding: 8bit 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. <<<----