Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6vQA-007u9U-RR for pgsql-general@arkaria.postgresql.org; Mon, 21 Apr 2025 17:59:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u6vQ8-007QPM-5p for pgsql-general@arkaria.postgresql.org; Mon, 21 Apr 2025 17:59:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6vQ7-007QP3-R0 for pgsql-general@lists.postgresql.org; Mon, 21 Apr 2025 17:59:04 +0000 Received: from sm-r-002-dus.org-dns.com ([89.107.70.11]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u6vQ5-001DbH-1g for pgsql-general@lists.postgresql.org; Mon, 21 Apr 2025 17:59:03 +0000 Received: from smarthost-dus.org-dns.com (localhost [127.0.0.1]) by smarthost-dus.org-dns.com (Postfix) with ESMTP id B9CBBA1CC2 for ; Mon, 21 Apr 2025 19:58:59 +0200 (CEST) Received: by smarthost-dus.org-dns.com (Postfix, from userid 1001) id AC253A1CBB; Mon, 21 Apr 2025 19:58:59 +0200 (CEST) X-Spam-Status: No, score=-1.1 required=5.0 tests=AWL,BAYES_00,DMARC_PASS, KAM_INFOUSMEBIZ,SPF_HELO_PASS,SPF_PASS autolearn=no autolearn_force=no version=4.0.1 Received: from ha01s018.org-dns.com (ha01s018.org-dns.com [62.108.32.138]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by smarthost-dus.org-dns.com (Postfix) with ESMTPS id 70123A1CBB for ; Mon, 21 Apr 2025 19:58:59 +0200 (CEST) Authentication-Results: ha01s018.org-dns.com; spf=pass (sender IP is 146.185.68.202) smtp.mailfrom=thiemo@gelassene-pferde.biz smtp.helo=dummy.faircode.eu Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated) Date: Mon, 21 Apr 2025 19:58:56 +0200 (GMT+02:00) From: Thiemo Kellner To: "pgsql-generallists.postgresql.org" Message-ID: In-Reply-To: <37a85e85-b4ff-4164-adab-12c8dc995922@aklaver.com> References: <20250420091033.n437fdrkihtjrncd@hjp.at> <20250421084717.4edbhu6a7duiqw42@hjp.at> <37a85e85-b4ff-4164-adab-12c8dc995922@aklaver.com> Subject: Re: Order of update MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Correlation-ID: X-PPP-Message-ID: <174525833932.564458.1767773371536200101@ha01s018.org-dns.com> X-PPP-Vhost: gelassene-pferde.biz X-POWERED-BY: wint.global - AV:CLEAN SPAM:OK List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 : > 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