pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nikola Ivacic <nikola@rs-pi.com>
To: pgsql-sql@postgresql.org
Subject: COPY command problems
Date: Tue, 24 Dec 2002 11:23:38 +0100
Message-ID: <007d01c2ab36$85d92760$1100a8c0@rspi> (raw)

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

view thread (4+ messages)  latest in thread

Message-ID: <007d01c2ab36$85d92760$1100a8c0@rspi>
Permalink:  ../007d01c2ab36$85d92760$1100a8c0@rspi/
Also on:    postgresql.org/message-id/007d01c2ab36$85d92760$1100a8c0@rspi

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: nikola@rs-pi.com
  Subject: Re: COPY command problems
  In-Reply-To: <007d01c2ab36$85d92760$1100a8c0@rspi>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox