Re: Do we want to enable foreign key constraints on subscriber?

2023-07-19 Thread Amit Kapila
On Wed, Jul 19, 2023 at 12:21 PM Kyotaro Horiguchi wrote: > > There's an issue brought up in the -bugs list [1]. Since triggers are > deactivated on a subscriber by default, foreign key constraints don't > fire for replicated changes. The docs state this is done to prevent > repetitive data

Do we want to enable foreign key constraints on subscriber?

2023-07-19 Thread Kyotaro Horiguchi
Hello. There's an issue brought up in the -bugs list [1]. Since triggers are deactivated on a subscriber by default, foreign key constraints don't fire for replicated changes. The docs state this is done to prevent repetitive data propagation between tables on subscribers. But foreign key