Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0BE78475843 for ; Tue, 24 Dec 2002 05:24:46 -0500 (EST) Received: from rs-pi.com (unknown [193.95.196.91]) by postgresql.org (Postfix) with ESMTP id 4C997474E61 for ; Tue, 24 Dec 2002 05:24:45 -0500 (EST) Received: from spot (fw.rs-pi.com [193.95.196.154]) by rs-pi.com (Postfix) with SMTP id 210258DE9 for ; Tue, 24 Dec 2002 11:29:42 +0100 (CET) Message-ID: <007d01c2ab36$85d92760$1100a8c0@rspi> From: "Nikola Ivacic" To: Subject: COPY command problems Date: Tue, 24 Dec 2002 11:23:38 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_007A_01C2AB3E.E79467A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/266 X-Sequence-Number: 10854 This is a multi-part message in MIME format. ------=_NextPart_000_007A_01C2AB3E.E79467A0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable 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 r= ecord field (not the end or begining) lp Nikola ------=_NextPart_000_007A_01C2AB3E.E79467A0 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
I need help
 
Has somebody experienced difficulties usin= g COPY=20 command on large files.
I have a large (250MB) file and each time = I insert=20 records I've got one or more (< 30 of cca 1079000)=20 corrupted
records. The number of corrupted records i= s not=20 constant (i.e. 1, 30, 7, 23 etc..)
 
p.s. the file is tab-nl separated and= =20 corruption is done in the middle of record field
(not the end or begining)
 
lp
 
Nikola
 
------=_NextPart_000_007A_01C2AB3E.E79467A0--