I have a table with unique index on two fields, lane\_id and position.

Now, I want to update row using this query:

```
UPDATE "teams_ticket" SET "position" = ("teams_ticket"."position" + 1) WHERE ("teams_ticket"."lane_id" = 1 AND "teams_ticket"."position" >= 0)

```

Which ends up with:

```
duplicate key value violates unique constraint "teams_ticket_position_bfcce9fa_uniq"

```

If I have more than one ticket.

How can I solve this issue?