Skip to content
pgdeadbolt

explicit-lock-table

Avoid LOCK TABLE in migrations.

Severity: warning

An explicit lock lasts until the transaction ends, so every later step in the migration runs while the table is locked.

Instead of

Section titled “Instead of”
BEGIN;
LOCK TABLE users IN ACCESS EXCLUSIVE MODE;
UPDATE users SET plan = 'free' WHERE plan IS NULL;
COMMIT;

Do

Section titled “Do”
-- Remove the lock, or keep the transaction tiny and set lock_timeout first.

To skip this rule for one statement, put -- pgdeadbolt-ignore explicit-lock-table on the line above it.