Hi everyone, When importing a bunch of data (> 85000 rows) I get an error I can't explain. The table into which I'm importing has a unique clause on (code, bedrijf). The rows in the source-table are unique in this aspect, yet when I do the import I get this "ERROR: duplicate key violates unique constraint "werknemer_bedrijf_key".
I checked the sourcetable a number of times, even COPYd the relevant columns to a textfile and did `uniq -d` and `uniq -D` (nothing non-unique found), tried to delete out non-unique rows (again nothing found). Is there a bug in the UNIQUE behaviour? I'm running postgresql 7.4.5-2 (from backports) on a debian stable server. Is there any way I can DEFER the unique clause, or remove it and put it back later? Thanks! ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])