Commits

DateSubjectAuthorReleases
2025-06-05 Doc: improve description of which role runs a trigger. Tom Lane 18.0
2025-01-23 Ensure that AFTER triggers run as the instigating user. Tom Lane 18.0
2024-09-09 Don't bother checking the result of SPI_connect[_ext] anymore. Tom Lane 18.0
2024-05-08 Doc: document that triggers can break referential integrity. Tom Lane 17.0
2021-09-01 Doc: clarify how triggers relate to transactions. Tom Lane 14.0
2021-09-01 Doc: clarify how triggers relate to transactions. Tom Lane 15.0
2018-03-18 Doc: note that statement-level view triggers require an INSTEAD OF trigger. Tom Lane 10.4
2018-03-18 Doc: note that statement-level view triggers require an INSTEAD OF trigger. Tom Lane 9.4.18
2018-03-18 Doc: note that statement-level view triggers require an INSTEAD OF trigger. Tom Lane 11.0
2018-03-18 Doc: note that statement-level view triggers require an INSTEAD OF trigger. Tom Lane 9.5.13
2018-03-18 Doc: note that statement-level view triggers require an INSTEAD OF trigger. Tom Lane 9.6.9
2018-03-18 Doc: note that statement-level view triggers require an INSTEAD OF trigger. Tom Lane 9.3.23
2017-09-16 Doc: add example of transition table use in a trigger. Tom Lane 10.0
2017-09-16 Doc: add example of transition table use in a trigger. Tom Lane 11.0
2017-09-16 Fix SQL-spec incompatibilities in new transition table feature. Tom Lane 10.0
2017-09-16 Fix SQL-spec incompatibilities in new transition table feature. Tom Lane 11.0
2015-05-24 Remove no-longer-required function declarations. Tom Lane 9.5.0
2011-04-08 Avoid extra whitespace in the arguments of <indexterm>. Tom Lane 9.1.0
2010-10-10 Support triggers on views. Tom Lane 9.1.0
2010-01-17 Improve the handling of SET CONSTRAINTS commands by having them search Tom Lane 9.0.0
2009-11-20 Add a WHEN clause to CREATE TRIGGER, allowing a boolean expression to be Tom Lane 9.0.0
2009-10-14 Support SQL-compliant triggers on columns, ie fire only if certain columns Tom Lane 9.0.0
2009-07-28 Add system catalog columns pg_constraint.conindid and pg_trigger.tgconstrindid. Tom Lane 9.0.0
2009-05-27 Improve documentation about function volatility: mention the snapshot Tom Lane 8.4.0
2009-01-06 Change a couple of ill-advised uses of INFO elog level to WARNINGs; in Tom Lane 8.4.0