Odoo Help


This community 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.


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

on 5/13/14, 6:05 AM 742 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?


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


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