Thanks for the pointer. I feel my doubts reflected. For such reasons, I prefer the UUID as surrogate key. No point in
tryingto 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