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.
[ Parent
| on HN ]
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.