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

Поиск
Список
Период
Сортировка
От Vlad Arkhipov
Тема How to check whether the row was modified by this transaction before?
Дата
Msg-id 50C05E2E.4080602@dc.baikal.ru
обсуждение
Ответы Re: How to check whether the row was modified by this transaction before?
Re: How to check whether the row was modified by this transaction before?
Список pgsql-hackers
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).

CREATE FUNCTION test_trigger()
RETURNS TRIGGER AS $$
BEGIN  IF OLD.xmin = txid_current() THEN    -- Do something.  ELSE    -- Do something else.  END IF;
END;
$$ LANGUAGE plpgsql;



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