prefer-identity

problem#

Serial types make permissions and schema management difficult. Identity columns are standard SQL and have more features and better usability.

solution#

Instead of:

create table app.users
(
    id  bigserial
)

Use:

create table app.users
(
    id  bigint generated by default as identity primary key
)

links#

problem
solution
links