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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
