Home > mailing lists

COPY command problems - Mailing list pgsql-sql

From	Nikola Ivacic
Subject	COPY command problems
Date	December 24, 2002 08:24:49
Msg-id	007d01c2ab36$85d92760$1100a8c0@rspi Whole thread Raw
Responses	Re: COPY command problems (Tom Lane <tgl@sss.pgh.pa.us>)
List	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)

Nikola

From: Jason Pyeron
Date: 23 December 2002, 22:12:10
Subject: corresponding primary key for max(column)?

From: Tom Lane
Date: 24 December 2002, 13:24:47
Subject: Re: COPY command problems