You have to delete one of duplicated row within table which doesn’t have a primary key:
delete from <table> where ctid = (select min(ctid) from <table>);