Lock table

sql

LOCK TABLE orders IN SHARE ROW EXCLUSIVE MODE;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Transactions, Savepoints, and Locking

Start an explicit transaction block.

Open In sheetsqlsame section

Persist all changes in the current transaction.

Open In sheetsqlsame section

Discard all uncommitted work.

Open In sheetsqlsame section

Mark a partial rollback point within a transaction.

Open In sheetsqlsame section

Undo work after the named savepoint while keeping the transaction open.

Open In sheetsqlsame section

Change isolation for the current transaction.

Open In sheetsqlsame section