If I create a new, empty table that is NOT partitioned and place a primary key on the ID column then copy the data to the new table I do not get the primary key violation. It's only when the new table is partitioned that I get the primary key violation error.