Skip to main content

require-lock-timeout

problem​

You must configure a lock_timeout to safely apply migrations. See "Safety requirements"

solution​

Configure a lock_timeout at the beginning of your migration file:

-- error, missing lock timeout
alter table t add column c boolean;
-- ok, lock timeout configured before ddl operations
set lock_timeout = '1s';
alter table t add column c boolean;

alternatively​

If your database connection is already configured with a lock timeout, you can safely ignore this rule.

See require-statement-timeout for the related statement_timeout check.