postgresql/no-update-primary-key

Why this matters

Primary keys are intended to be immutable: foreign-key references and external systems may hold the old value. By default the rule treats `id` and `<table>_id` as primary-key columns; override with `pkColumnNames` for non-conventional schemas.

Examples

UPDATE users SET id = 5 WHERE id = 1;

UPDATE users SET name = 'foo' WHERE id = 1;

UPDATE orders SET total = 100, status = 'paid' WHERE id = 2;

Configure it

// eslint.config.js
import postgresql from "eslint-plugin-postgresql";

export default [
  {
    files: ["**/*.sql"],
    languageOptions: {
      parser: postgresql.configs.recommended.languageOptions.parser,
    },
    plugins: { postgresql },
    rules: {
      "postgresql/no-update-primary-key": [
        "error",
        {
          pkColumnNames: ["id"],
        },
      ],
    },
  },
];

Options

pkColumnNames string[] default: ["id"]

Explicit list of primary-key column names. Replaces the default. The `<table>_id` heuristic still applies in addition.