allow trigger to get updated columns

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема allow trigger to get updated columns
Дата
Msg-id 11c5f156-67a9-0fb5-8200-2a8018eb2e0c@2ndquadrant.com
обсуждение исходный текст
Ответы Re: allow trigger to get updated columns  (Daniel Gustafsson <daniel@yesql.se>)
Список pgsql-hackers
This is a change to make the bitmap of updated columns available to a 
trigger in TriggerData.  This is the same idea as was recently done to 
generated columns [0]: Generic triggers such as tsvector_update_trigger 
can use this information to skip work if the columns they are interested 
in haven't changed.  With the generated columns change, perhaps this 
isn't so interesting anymore, but I suspect a lot of existing 
installations still use tsvector_update_trigger.  In any case, since I 
had already written the code, I figured I post it here.  Perhaps there 
are other use cases.


[0]: 
https://www.postgresql.org/message-id/flat/b05e781a-fa16-6b52-6738-761181204567@2ndquadrant.com

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Вложения

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

Предыдущее
От: Prabhat Sahu
Дата:
Сообщение: Re: [Proposal] Global temporary tables
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager