Is it possible to get around the "duplicate key value violates unique constraint" error when updating?

Question

PostgreSQL

Is it possible to bypass the unique key constraint if I update the same row with new data?

for example table cards [id, user_id, status]

user_id is a unique value.

we have record

180, 1, "bla-bla"

Do

UPDATE cards SET user_id  = 1, status = 'test', WHERE id = 180

We get an error. How to avoid it?

Answer 1

duplicate key value violates unique constraint

google translate:
duplicate key value violates unique constraint
doesn't look like anything?
one of the indexes of type unique in the table does not allow, the value after the update will be repeated