Prefer identity columns (or uuid) over serial

Prefer identity columns (or uuid) over serial | BeforeMerge Rules | BeforeMerge

Why this matters

serial is not a real type — it silently creates a sequence and a default, with quirky ownership and grant behavior. GENERATED ALWAYS AS IDENTITY is SQL-standard, prevents accidental manual inserts into the key, and is easier to reason about. Use uuid when you need globally-unique or externally-generated ids.

-- bad
id serial PRIMARY KEY
 
-- good
id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY

Why This Matters

Related Rules

Catch this automatically on every PR

Why this matters