News for hackers. Stuff that matters.
Re:PostgreSQL and UUID as Primary Key by foreigner on Saturday July 06, 2024 @04:09AM (#40888932)
Be advised using the last auto-incremented value as a "high water mark" and getting everything greater than that is not 100% reliable, because in some scenarios auto-incrementing values can be written out of order.
Re:PostgreSQL and UUID as Primary Key by Koffiepoeder on Saturday July 06, 2024 @09:57AM (#40890506)
Yup, not many people seem to know about CACHE vals and/or sequence reservation. It's a problem that I've had to explain a couple of times already to colleagues. And unfortunately hidden assumptions are oft the most dangerous kind.