News for hackers. Stuff that matters.

A comment on Postgres sequences can skip 32 unexpectedly.

Re:Postgres sequences can skip 32 unexpectedly by codr7 on Friday July 16, 2021 @10:11AM (#27856383)
Yep, already walked that path with invoice numbers.

The only thing you can say for sure about a sequence is the next number will be greater, which is not good enough for many kinds of identifiers.

[ Parent | on HN ]
Re:Postgres sequences can skip 32 unexpectedly by gmfawcett on Friday July 16, 2021 @10:46AM (#27856770)
You can't even say that for sure. Sequences can be exhausted, and can be configured to cycle (wrap around when max value is reached).
[ Parent | on HN ]