how to tell if a tuple has been inserted in current transaction

Поиск
Список
Период
Сортировка
От pg noob
Тема how to tell if a tuple has been inserted in current transaction
Дата
Msg-id CAPNY-2UFrBbeN9A_5Siwcu-QhHv_R5kkJMii4GcdPzu8JGoR9Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to tell if a tuple has been inserted in current transaction  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-novice

Hi all,

I have a trigger function which is getting invoked on insert/update and within that trigger I would like to know if some tuple, from a different table referenced by foreign key constraint from the table with the trigger on it, was inserted within the same transaction as the insert/update that caused the trigger to fire.

I found that I can tell if the foreign tuple was inserted or updated by checking if its xmin == select txid_current(), but there doesn't appear to be any way to know if it was modified because of an INSERT or an UPDATE.  I would like to distinguish between whether it was an insert or update that caused the row to be modified.  Is this possible?

Thank you for any information.

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

Предыдущее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: JOIN producing duplicate results
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: how to tell if a tuple has been inserted in current transaction