Re:PostgreSQL and UUID as Primary Key
by withinboredom on Sunday July 07, 2024 @10:06AM
(#40897846)
The prefixes have to be in order though. You cannot start a prefix with A after already using prefix starting with B.
However you are allowed to have multiple sequences, differentiated through a prefix, but all starting at 0. That’s what we recently did to switch invoice generation tools (we actually still run both of them alongside each other atm).
Of course you could still drop some invoices from the end when you do this, but I guess tax authorities accept that risk.