CTID: Anyway to lock it?

Поиск
Список
Период
Сортировка
От Jim Hines
Тема CTID: Anyway to lock it?
Дата
Msg-id 200211041359.48031.jhines@wdtv.com
обсуждение исходный текст
Ответы Re: CTID: Anyway to lock it?
Список 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 по дате отправления: