Clarification: How many2many tables are managed

[omalbastin]

Its not an issue. Just want to know how bucardo handles the many2many tables in odoo as those tables dont have a primary key.

[anassahmed]

Bucardo doesn't do anything special in this case, it'll record the SQL queries Odoo will do on these tables and try to re-execute them everywhere else; which may lead to a mess without a primary key IMHO.

At the end of the day, this was an experiment for anyone who wants to know if he can use Bucardo with Odoo.

I'm waiting for PostgreSQL to implement Multi-Master Logical Replication (with Transaction-based log that also includes CREATE queries), because installing a new module in odoo (or sometimes creating a new sequence) don't get replicated at all with Bucardo (This is called DDL replication).

[mohamedmshokry]

Hi,

Too late I know but though to leave my comment here for anyone passing by recently.

• Bucardo doesn't support replicating tables with no primary keys
• Bucardo doesn't replicate DDL it only replicate DML. Any change in Table structure will break the sync
• Bucardo manages the multi master replicaion though conflict strategy which must be specified while creating multi-master replication. More on it Here