On Sun, 5 Jan 2003, Jack Flak wrote:
> Greetings Group,
>
> I'm running 7.1.
>
> Basically, my question is this: how do I delete an exact dup without
> deleting the original?
You can use one of the other hidden fields. ctid will be unique for the
various rows, but I'm not sure of a good way to bulk delete them (tids
don't seem to have comparison operators so the normal ways I can think of
don't work).
If all of the new rows were added by a single transaction (through copy
say) you'd probably be able to delete all the rows added by that
transaction using the xmin column. Find the xmin belonging to those rows
and delete all the rows having that xmin.