Re: Logical Replication postgres 10.5

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Tue, 28 May 2019 10:19:46 +0300



    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