Comment by brycelarkin

For postgres, you want to use “bigint generated always as identity” instead of bigserial.