requireStatementTimeout

Diagnostic Category: lint/safety/requireStatementTimeout

Since: vnext

Sources: - Inspired from: pgfence/missing-statement-timeout

Description

Dangerous lock statements should be preceded by SET statement_timeout.

Long-running statements holding locks can block other operations. Setting a statement_timeout ensures the statement fails rather than running indefinitely.

Examples

Invalid

ALTER TABLE users ADD COLUMN email TEXT;

code-block.sql:1:1 lint/safety/requireStatementTimeout ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

  ! Statement takes a dangerous lock without a statement_timeout set.

  > 1 │ ALTER TABLE users ADD COLUMN email TEXT;
      │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    2 │ 

  i Run SET statement_timeout = '...' before this statement to prevent it from running indefinitely.

Valid

CREATE INDEX CONCURRENTLY users_email_idx ON users(email);

How to configure

{
  "linter": {
    "rules": {
      "safety": {
        "requireStatementTimeout": "error"
      }
    }
  }
}