Odoo Help

Welcome!

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.

0

Remove NOT NULL Constraint in Product

By
Sergio Fernández
on 2/1/16, 8:06 AM 463 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
0
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;

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

1 follower(s)

Stats

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