Thanks for the pointer. I feel my doubts reflected. For such reasons, I prefer the UUID as surrogate key. No point in trying to establish an order or even id arithmetics.
21.04.2025 18:44:27 Adrian Klaver <adrian.kla...@aklaver.com>: > On 4/21/25 09:12, Thiemo Kellner wrote: >> I wonder if that is a corner case. Updating a unique key sounds to me like a >> design flaw in the first place. >> > > Check out this the thread below for discussion on that topic: > > https://www.postgresql.org/message-id/dkbnfi$7g5$1...@sea.gmane.org > > -- > Adrian Klaver > adrian.kla...@aklaver.com