postgresql

FOR UPDATE Locks a Parent Row, Not Child Rows in Postgres

Locking a parent row with SELECT FOR UPDATE does not protect its child rows under READ COMMITTED. Three traps it creates, and the fix for each one.