bug
Sandeep Joshi <sjoshi@zambeel.com>
From: Sandeep Joshi <sjoshi@Zambeel.com>
To: pgsql-general@postgresql.org
Date: 2000-12-04T20:50:59Z
Lists: pgsql-general
Hi, I was trying to populate a database from an ascii file using copy command. table had 5 columns and 2 of them had "references" column and 3 of them were involved in primary key clause. I was trying to populate 1 million rows. The process didn't finish for 12 hours !!! But, when removed foreign keys and primary keys it took less than 10-20 minutes. Also, if a particular didn't qualify from the "data" file then whole process would abort. I think it should skip that row and continue. thanks, Sandeep