I used to have this kind of situation in Oracle.
I used to do it in "work around" way.
1.Create a temp table of same structure of original table.
2. Do a " Insert into Temp_table values select * from Original_Table.
3.Then Using the same style of insert statement , Insert the rows from the temp_table to Original Table.
This methos id advantageous as this will not mess up you original table as you have a backup of original table(i.e ut temp table)
(provided, there cannot be duplicate constraint)