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