Hi,

SQL constrains will work for new and existing db. In existing database, you may have some records which already violates this constrains and thus it is not working.

So manually fix the existing violated records and apply the SQL constrains. In case if you can't fix existing records, then you have to use api.constrains for new records.

Thanks

Hi,

finally it work in my existing db, So the solution is to search for any duplicating data for the field that we want to applied to sql_constraint
remove all duplicate data

remove compiled file "model.pyc"

restart odoo-service

Refresh your browser

and it will work fine

This is Help for You,

Syntax,

_sql_constraints = [('<sql_constraints_id>', 'unique(<Your field name>)', '<Custom Message>')]

Example,

_sql_constraints = [('user_unique', 'unique(userid)', 'User already exists.')]