I want to remove _sql_constraints (database level).
For example in account_invoice.py there is a constraints on number field. Now I want to remove it.
Can anyone have idea how to deal with this?
Thank you.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
3
Replies
42091
Views
you could remove it using psql command. for example if you have the following constraint
_sql_constraints = [
('phone_company_unique', 'unique(type,phone)', 'The phone unique among companies!')
]
you could use:
ALTER TABLE res_partner DROP CONSTRAINT res_company_phone_company_unique;
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Mar 15
|
11016 | ||
|
1
Oct 25
|
5235 | ||
|
0
Dec 24
|
10233 | ||
|
3
Sep 24
|
22586 | ||
|
5
Dec 24
|
54529 |
