A while ago I created this table to easily understand which kind of trigger gets executed under what setting of session_replication_role. There's already a description in the docs which describes it:
<quote>
Simply enabled triggers will fire when the replication role is
"origin" (the default) or
"local". Triggers configured as
ENABLE REPLICA will only fire if the session is in
"replica" mode, and triggers configured as
ENABLE ALWAYS will fire regardless of the current replication mode.
</quote>
I was wondering if this table would add value for anyone looking at those statements and trying to develop a similar table in their heads.
+--------------------------+ | session_replication_role |+------------------------+--------+---------+-------+| ALTER TABLE Command | origin | replica | local |+------------------------+--------+---------+-------+| ENABLE TRIGGER | x | | x || ENABLE REPLICA TRIGGER | | x | || ENABLE ALWAYS TRIGGER | x | x | x |+------------------------+--------+---------+-------+Regards,
--
Gurjeet Singh
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
