Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
3 Odgovori
41242 Prikazi

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.

Avatar
Opusti
Best Answer

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;

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
2
mar. 15
10228
0
dec. 24
9448
3
sep. 24
21592
5
dec. 24
52884
4
jul. 24
10553