Thread: Truncate cascade doesn´t work with BDR

Truncate cascade doesn´t work with BDR

From
"Ruth Melendo"
Date:

Hi,

 

I have 2 tables in PostgreSQL synchronized with BDR.

 

I do truncate cascade in one node and it doesn´t take effect in the other. Take a look to this screenshot:

 

 

 

I have now BDR configurated OK and the rest of the tests were OK until now. To solve it, I edit data in the table and delete the rows. No error in logs even when data is not the same in both nodes.

 

I think it´s a bug.

 

Ruth Patricia Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.

T: +34 976 465656   Ext. 179

F: +34 976 465722

www.teltronic.es

 

Logo40

 

Before printing this e-mail please consider your environmental responsibility.

*****  DISCLAIMER  *****

This message is intended exclusively for the named person. It may contain confidential, propietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. Your must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorised to state them to be the views of TELTRONIC. If the addressee of this message does not consent to the use of internet e-mail, please communicate it to us immediately.

 

Re: [BUGS] Truncate cascade doesn´t work with BDR

From
Venkata Balaji N
Date:

On Wed, Mar 4, 2015 at 10:26 PM, Ruth Melendo <rmelendo@teltronic.es> wrote:

Hi,

 

I have 2 tables in PostgreSQL synchronized with BDR.

 

I do truncate cascade in one node and it doesn´t take effect in the other. Take a look to this screenshot:

 


Before you lodge this as a bug. If you have installed the latest BDR, Do you see anything in the BDR catalog table : conflict_history_table ??

Regards,
Venkata Balaji N

RE: [BUGS] Truncate cascade doesn´t work with BDR

From
"Ruth Melendo"
Date:

I will retry it. Now, I have my database working right having done it by hand. I will test it again soon.

 

Thanks

 

Ruth Patricia Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.

T: +34 976 465656   Ext. 179

F: +34 976 465722

www.teltronic.es

Logo40

 

De: Venkata Balaji N [mailto:nag1010@gmail.com]
Enviado el: miércoles, 04 de marzo de 2015 23:26
Para: Ruth Melendo
CC: pgsql-bugs@postgresql.org
Asunto: Re: [BUGS] Truncate cascade doesn´t work with BDR

 

 

On Wed, Mar 4, 2015 at 10:26 PM, Ruth Melendo <rmelendo@teltronic.es> wrote:

Hi,

 

I have 2 tables in PostgreSQL synchronized with BDR.

 

I do truncate cascade in one node and it doesn´t take effect in the other. Take a look to this screenshot:

 

 

Before you lodge this as a bug. If you have installed the latest BDR, Do you see anything in the BDR catalog table : conflict_history_table ??

Regards,

Venkata Balaji N