Lock on Insert?

Question

PostgreSQL

Good evening!

There is a games table, all new games are created in it (insert)
| id | creator_id | ... |

How to correctly lock the table/user action so that there is no race condition?
Because sometimes when creating a game, 2 identical ones are created.
When blocked, other requests for creation should be processed normally

Answer 1

Best of all is unique constraint.
If not, then pg_advisory_lock() .