COPY command problems

From: "Nikola Ivacic" <nikola(at)rs-pi(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: COPY command problems
Date: 2002-12-24 10:23:38
Message-ID: 007d01c2ab36$85d92760$1100a8c0@rspi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I need help

Has somebody experienced difficulties using COPY command on large files.
I have a large (250MB) file and each time I insert records I've got one or more (< 30 of cca 1079000) corrupted
records. The number of corrupted records is not constant (i.e. 1, 30, 7, 23 etc..)

p.s. the file is tab-nl separated and corruption is done in the middle of record field
(not the end or begining)

lp

Nikola

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-12-24 15:24:49 Re: COPY command problems
Previous Message Jason Pyeron 2002-12-24 00:12:06 corresponding primary key for max(column)?