On 28/5/19 8:21 π.μ., Mai Peng wrote:
Hello,
Is Logical Replication ignore foreign key constraint ? How does it possible ?
The apply process on the subscriber runs with
session_replication_role set to
replica, this limits trigger firing, excluding normal triggers . FK constraints in pgsql are implemented with triggers, hence the behavior you are observing.
Thank you
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt