SQL constraint error messages are not parsed correctly anymore when there's an unique index

[luisg123v]

Impacted versions:

• 14.0
• 13.0

Steps to reproduce:

• Go to Settings -> User Interface -> User-defined Filters
• Open any filter (e.g. "By Country")
• Duplicate the filter and save it with the same name as the original one

Current behavior:
The following error message is shown:

duplicate key value violates unique constraint "ir_filters_name_model_uid_unique_action_index"
DETAIL: Key (lower(name::text), model_id, COALESCE(user_id, '-1'::integer), COALESCE(action_id, '-1'::integer))=(by country (copy), account.invoice.report, -1, -1) already exists.

Expected behavior:
The message "ilter names must be unique" should be shown, instead of the raw SQL constraint.

The message is defined on this SQL constraint. Since there's an unique index and they share the same prefix, the SQL constraint's error message should be used when the unique index is triggered.

This worked correctly in Odoo < 13.0

Video/Screenshot link (optional):

Support ticket number submitted via odoo.com/help (optional):
OPW #2596482

[luisg123v]

CC @angelJuaGar @moylop260 @hugho-ad