Re: How to check whether the row was modified by this transaction before?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to check whether the row was modified by this transaction before?
Дата
Msg-id 7386.1354820372@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to check whether the row was modified by this transaction before?  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: How to check whether the row was modified by this transaction before?
Список pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2012-12-06 15:08:51 -0300, Alvaro Herrera wrote:
>> Vlad Arkhipov <arhipov@dc.baikal.ru> writes:
>>> In a BEFORE UPDATE trigger I need to know whether the row was previously
>>> modified by this transaction. Is it safe to use xmin and txid_current()
>>> for this purpose (xmin is 32-bit txid type but txid_current() returns
>>> 64-bit bigint).

> I wonder if we shouldn't have a function txid_is_current(xid);

Yeah, I was wondering that too, and wanted to know if the OP had a
use-case that was mainstream enough to justify adding such a function.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Setting visibility map in VACUUM's second phase
Следующее
От: Andres Freund
Дата:
Сообщение: Re: ALTER TABLE ... NOREWRITE option