3 ms·
> Database "sequence" types that are used to create integer IDs often no not make any guarantees about being gap-free. Yep, the docs from Postgres are very cle
by insanitybit 3y ago
> Database "sequence" types that are used to create integer IDs often no not make any guarantees about being gap-free.
Yep, the docs from Postgres are very clear that `serial` has gaps. But you can also just create a counter table and manually manage the sequence if you have strict serial requirements.
Of course, if you have serial requirements a UUID would already not be viable.