warn-extension-version-pin

What It Detects

CREATE EXTENSION without VERSION clause. Pin the version for reproducible migrations.

Why It's Dangerous

Without a VERSION clause, CREATE EXTENSION installs the server default version, which can differ between environments. This makes migrations non-reproducible.

Bad Example

CREATE EXTENSION IF NOT EXISTS pgcrypto;

Good Example

CREATE EXTENSION IF NOT EXISTS pgcrypto VERSION '1.3';

Configuration

Disable this rule:

# .migrationpilotrc.yml
rules:
  MP078: false

Or change its severity:

# .migrationpilotrc.yml
rules:
  MP078:
    severity: warning