"Weerts, Jan" <j.weerts@xxxxxxxxxx> writes: > Scott Marlowe wrote: >> Can you get set of fields in that row to uniquely identify it by? >> >> If so, see if you can update that column to something else and >> continue > The only way would be to update by primarykey. But since the > select on the primarykey field shows this "strange" ordering, > I wonder, what effect an update would have. CTID always works: SELECT ctid, otherstuff FROM table WHERE ... ; eyeball otherstuff to determine row you wish to hack UPDATE table SET ... WHERE ctid = '...'; Note: the act of UPDATE changes the row's ctid, don't be surprised. regards, tom lane
