Override SQL constraint

Question

res.currency.rate has this original constraint
CONSTRAINT res_currency_rate_currency_uniq UNIQUE (name)
can I override it somehow to make it a unique name for each currency and not unique name per all table

faOtools · Answer

You can add an extra param to check the uniqueness:
unique(name,currency_id) However, take into account that it should be done in original model: in inherited models it will not work. Have also a look at -  https://www.odoo.com/forum/help-1/question/remove-sql-constraints-5431 [1]  - for extra details regarding removing SQL constraints.

[1] https://www.odoo.com/forum/help-1/question/remove-sql-constraints-5431

Powiązane posty	Odpowiedzi	Widoki
how to use constraint and sql constraint? Rozwiązane constraint sql	6 gru 23	68652
Sql constraints occurs when edit in record constraint edit sql	0 lut 16	4
How to block duplicating RECORDS (with the same employee_id)? constraint sql openerp7	0 gru 15	4460
CHECK sql_constraints v7 constraint sql	2 mar 15	11913
Usage Of SQl Queries In odoo sql	1 lis 22	8368

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!