Odoo Help


Remove NOT NULL Constraint in Product

Sergio Fernández
on 2/1/16, 8:06 AM 936 views

Good morning!.

I've recently installed and then uninstalled this module https://www.odoo.com/apps/modules/8.0/product_sequence/

Even after removing it, the constraint NOT NULL over Contact Reference doesn't disappear.

I've entered psql, but I doubt where do I need to remove the constraint and how.

Would be something like this?:

ALTER TABLE product_product DROP CONSTRAINT ref;

Thank you!

Anyone knows?

Sergio Fernández
on 2/3/16, 2:41 AM
Sergio Fernández
On 2/3/16, 3:24 AM

This is the expression:

ALTER TABLE product_product ALTER COLUMN default_code DROP NOT NULL;

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

1 follower(s)


Asked: 2/1/16, 8:06 AM
Seen: 936 times
Last updated: 2/3/16, 3:51 AM