[Bucardo-general] Tables with no primary key.

Periko Support pheriko.support at gmail.com
Fri Oct 21 18:29:22 UTC 2016


Bucardo reject tables without primary key.

In odoo 7 db, we have this tables without pkey:

public.ir_model_relation
public.wkf_witm_trans

Them I remove those table from the sync job.

But reading the logs I found this:


 (12300) [Thu Oct 20 23:23:23 2016] MCP Table public.ir_model is
referenced by public.ir_model_relation(ir_model_relation_model_fkey),
which is not part of this sync!
(12300) [Thu Oct 20 23:23:23 2016] MCP Table public.ir_module_module
is referenced by
public.ir_model_relation(ir_model_relation_module_fkey), which is not
part of this sync!
(1759) [Thu Oct 20 23:29:33 2016] MCP Table public.ir_model is
referenced by public.ir_model_relation(ir_model_relation_model_fkey),
which is not part of this sync!
(1759) [Thu Oct 20 23:29:33 2016] MCP Table public.ir_module_module is
referenced by public.ir_model_relation(ir_model_relation_module_fkey),
which is not part of this sync!
(6124) [Fri Oct 21 09:33:37 2016] MCP Table public.ir_model is
referenced by public.ir_model_relation(ir_model_relation_model_fkey),
which is not part of this sync!
(6124) [Fri Oct 21 09:33:37 2016] MCP Table public.ir_module_module is
referenced by public.ir_model_relation(ir_model_relation_module_fkey),
which is not part of this sync!

Which is clear the warning.

I ask to our developers if we can add pkey to those tables, but they
didn't want to touch them because they are odoo internal tables.

Someone in the past with this issue?

I want to add pkey but don't know if this will affect odoo operation,
those tables are empty.

Any recommendation I will appreciate, thanks.


More information about the Bucardo-general mailing list