Skip to Content
This question has been flagged
1 Reply
1153 Views
Avatar
Andre de Buhr

Hello,

when i edit/change a sql_contraint in my module in will not update the contraint in the Database.

What is the best way to update in sql_contraint in Odoo 15 without deleting and reinstall the module?

Thanks

Avatar
Discard
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

By keeping the same name, you can modify existing SQL constrains via custom modules.

For example, if you need to change below constrain

_sql_constraints = [
    ('positive_color', 'CHECK(color >= 0)', 'The color code must be positive!')
]

In your custom module,

_sql_constraints = [
    ('positive_color', 'CHECK(color > 0)', 'The color code must be greater than zero!')
]


Thanks

Avatar
Discard