Re: [SQL] import ignoring duplicates

2010-05-16 Thread Scott Marlowe
On Sun, May 16, 2010 at 12:38 PM, Mark Fenbers wrote: > I am using psql's \copy command to add records to a database from a file. >  The file has over 100,000 lines.  Occasionally, there is a duplicate, and > the import ceases and an internal rollback is performed.  In other words, no > data is im

Re: [SQL] import ignoring duplicates

2010-05-16 Thread Tim Landscheidt
Mark Fenbers wrote: > I am using psql's \copy command to add records to a database > from a file. The file has over 100,000 lines. > Occasionally, there is a duplicate, and the import ceases > and an internal rollback is performed. In other words, no > data is imported even if the first error o

[SQL] import ignoring duplicates

2010-05-16 Thread Mark Fenbers
I am using psql's \copy command to add records to a database from a file. The file has over 100,000 lines. Occasionally, there is a duplicate, and the import ceases and an internal rollback is performed. In other words, no data is imported even if the first error occurs near the end of the f