Blog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2025 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/PostgreSQL
PostgreSQLmedium

What does `SELECT ... FOR UPDATE` do in PostgreSQL?

Tags
#locking#for-update#transactions
Back to categoryPractice quiz

Answer

It locks the selected rows for the duration of the transaction, preventing other transactions from updating (or locking) them until you commit/rollback. It’s used to safely read-modify-write without lost updates.

Related questions

PostgreSQL
What are advisory locks in PostgreSQL and when do they help?
#postgres#locking#advisory-locks
PostgreSQL
Sequences/IDENTITY: why can generated IDs have gaps?
#sequence#identity#transactions
PostgreSQL
How do deadlocks happen in Postgres and how do you reduce them?
#deadlock#locking#transactions
PostgreSQL
Explain transactions and isolation levels in PostgreSQL.
#transactions#isolation#acid
Databases
Autocommit vs explicit transactions: when does it matter?
#database#transactions#autocommit
Databases
Isolation levels: what’s the difference between Read Committed, Repeatable Read, and Serializable?
#database#transactions#isolation