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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
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 - for extra details regarding removing SQL constraints.