Thread

bug

Sandeep Joshi <sjoshi@zambeel.com> — 2000-12-04T20:50:59Z

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