Odoo Help


why my sql constraint keeps on being deleted when I update a module?

on 5/13/14, 6:05 AM 1,083 views

Hi, I've created a new module that inherits from "product" module and replaces the foreign key "product_supplierinfo_product_id_fkey" that refers to "product_template" by an other foreign key that refers to table "product_product. The module works fine, but when I update the module "product", it tries to restore the first constraint instead of the new one, so I get an integrity error because I already have lines that refer to product_product and Openerp searches for product templates with those ids but can't find them. 

This module was developped since Openerp 6 and I didn't have a problem with it. In openerp 6, when I update the product module, it does not restore the constraints.

Does something has changed in Openerp 7 about the module updates?


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 5/13/14, 6:05 AM
Seen: 1083 times
Last updated: 3/16/15, 8:10 AM