CTID: Anyway to lock it? - Mailing list pgsql-odbc

From Jim Hines
Subject CTID: Anyway to lock it?
Date
Msg-id 200211041359.48031.jhines@wdtv.com
Whole thread Raw
Responses Re: CTID: Anyway to lock it?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
Hello,
I have a piece of software that uses specific record numbers in order to pull
data from PG. It uses this query:
select "votes" ,  CTID, OID from database where ctid in ('(27, 55)')'

Apparently the CTID changes per record with each update. Is there anyway to
lock the CTID so that it doesn't change everytime I update a record?

thanks,


--
Jim Hines


pgsql-odbc by date:

Previous
From: "Antonio Pennino"
Date:
Subject: MFC, CRecordset, crash
Next
From: Tom Lane
Date:
Subject: Re: CTID: Anyway to lock it?