Skip to main content

prefer-bigint-over-smallint

problem​

Using 16 bit integer fields can result in hitting the max int limit.

solution​

Use 64 bit integer field instead, like BIGSERIAL or BIGINT.

smallserial​

Instead of:

CREATE TABLE posts (
  id smallserial primary key
)

Use:

CREATE TABLE posts (
  id bigserial primary key
)

smallint​

Instead of:

CREATE TABLE posts (
  id smallint primary key
)

Use:

CREATE TABLE posts (
  id bigint primary key
)

See "prefer-bigint-over-int" for a simliar lint rule against 32 bit integers.