[GENERAL] BDR replication and table triggers

2017-05-02 Thread jamesadams89
Hi, I have some questions regarding how BDR interacts with triggers. I have two databases that are both joined to the same BDR group and correctly replicating between one another sharing a table created as: create table testtable( key varchar(16) NOT NULL PRIMARY KEY, data jsonb

Re: [GENERAL] BDR replication and table triggers

2017-05-02 Thread Alvaro Aguayo Garcia-Rada
ite: www.ocs.pe - Original Message - From: "jamesadams89" To: "PostgreSql-general" Sent: Wednesday, 26 April, 2017 07:48:03 Subject: [GENERAL] BDR replication and table triggers Hi, I have some questions regarding how BDR interacts with triggers. I have two databases t

Re: [GENERAL] BDR replication and table triggers

2017-05-02 Thread Sylvain Marechal
rds, > > Alvaro Aguayo > Jefe de Operaciones > Open Comb Systems E.I.R.L. > > Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) > 954183248 > Website: www.ocs.pe > > - Original Message ----- > From: "jamesadams89" > To: "

Re: [GENERAL] BDR replication and table triggers

2017-05-02 Thread Craig Ringer
> However if I perform any INSERT, UPDATE or DELETE operations on > DB2 and these changes propagate over to DB1 via BDR I do not see DB1 firing > any triggers. Is this intended behavior? Yes. > My current understanding is that > BDR is unable to invoke Postgres triggers as it operates on the row