News for hackers. Stuff that matters.
Re:PostgreSQL and UUID as Primary Key by tinodb on Sunday July 07, 2024 @03:12AM (#40895814)
In the Netherlands gaps aren’t allowed either, and I’m surprised that it is elsewhere, as that allows to you get rid of unwanted invoices whenever you want.

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.

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.