Re: Order of update
Thiemo Kellner <thiemo@gelassene-pferde.biz>
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-04-21T17:58:56Z
Lists: pgsql-general
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.klaver@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.klaver@aklaver.com