"Weerts, Jan" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
