---
source: crates/squawk_linter/src/rules/prefer_identity.rs
expression: "lint_errors(sql, Rule::PreferIdentity)"
---
warning[prefer-identity]: Serial types make schema, dependency, and permission management difficult.
╭▸
3 │ id serial
│ ━━━━━━
│
├ help: Use an `IDENTITY` column instead.
╭╴
3 - id serial
3 + id integer generated by default as identity
╰╴
warning[prefer-identity]: Serial types make schema, dependency, and permission management difficult.
╭▸
6 │ id serial2
│ ━━━━━━━
│
├ help: Use an `IDENTITY` column instead.
╭╴
6 - id serial2
6 + id smallint generated by default as identity
╰╴
warning[prefer-identity]: Serial types make schema, dependency, and permission management difficult.
╭▸
9 │ id serial4
│ ━━━━━━━
│
├ help: Use an `IDENTITY` column instead.
╭╴
9 - id serial4
9 + id integer generated by default as identity
╰╴
warning[prefer-identity]: Serial types make schema, dependency, and permission management difficult.
╭▸
12 │ id serial8
│ ━━━━━━━
│
├ help: Use an `IDENTITY` column instead.
╭╴
12 - id serial8
12 + id bigint generated by default as identity
╰╴
warning[prefer-identity]: Serial types make schema, dependency, and permission management difficult.
╭▸
15 │ id smallserial
│ ━━━━━━━━━━━
│
├ help: Use an `IDENTITY` column instead.
╭╴
15 - id smallserial
15 + id smallint generated by default as identity
╰╴
warning[prefer-identity]: Serial types make schema, dependency, and permission management difficult.
╭▸
18 │ id bigserial
│ ━━━━━━━━━
│
├ help: Use an `IDENTITY` column instead.
╭╴
18 - id bigserial
18 + id bigint generated by default as identity
╰╴
warning[prefer-identity]: Serial types make schema, dependency, and permission management difficult.
╭▸
21 │ id BIGSERIAL
│ ━━━━━━━━━
│
├ help: Use an `IDENTITY` column instead.
╭╴
21 - id BIGSERIAL
21 + id bigint generated by default as identity
╰╴