(database locking for update) booking seat for x, database handling

seat.sql

CREATE TABLE t_flight AS  
  SELECT * FROM generate_series(1, 200) AS id; 
          
// concurrently we can call
SELECT * FROM t_flight LIMIT 2 FOR
UPDATE SKIP LOCKED;

// first time: 1, 2
// second time: 3, 4
// ....

// FOR UPDATE will have an impact on foreign keys
// if select (... table with foreign key reference b) for update is marked, then update on b will be blocked

// more on selecting the correct type of lock https://gist.github.com/prithvihv/dcf6f23999504f5103070d8635912b16