I have a CSV (tab-delimited in fact) file with 7,590,051 lines, according to
wc -l, which I want to import using
COPY FROM. I removed the table's primary key, so it has no constraints.
COPY customer FROM '.../customer.dsv' WITH DELIMITER E'\t' CSV HEADER; and it reported 7,588,671 rows imported and no errors, so it's missing 1,379 rows (already discounting the header line).
Since PostgreSQL didn't report any errors, how do you suggest I troubleshoot which rows are missing (and why they are missing)?