Skip to main content

prefer-bigint-over-smallint

problem​

Using 16 bit integer fields can result in hitting the max smallint 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.