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.96) (envelope-from ) id 1wcydS-003nPz-1j for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Jun 2026 04:57:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wcydQ-008qBk-1k for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Jun 2026 04:57:48 +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.96) (envelope-from ) id 1wcydQ-008qBb-0n for pgsql-hackers@lists.postgresql.org; Fri, 26 Jun 2026 04:57:48 +0000 Received: from mail-pf1-x430.google.com ([2607:f8b0:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wcydO-00000000Hw2-0T7q for pgsql-hackers@lists.postgresql.org; Fri, 26 Jun 2026 04:57:47 +0000 Received: by mail-pf1-x430.google.com with SMTP id d2e1a72fcca58-845b965c1c4so275264b3a.3 for ; Thu, 25 Jun 2026 21:57:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782449864; x=1783054664; darn=lists.postgresql.org; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:from:to:cc:subject :date:message-id:reply-to; bh=6VsXntDLQe0smfl9QloUZj/9wTE4M6QA+coFCsXtU8Y=; b=cJQzNqolM5jlPEodcza/wLHSDYccXBtmY3XTBh4M1muoXgae9PbKdbCBvNmygeQwFn Z8nmHgDrD+FvNj9CyfgLqqM0ciI1bY2+al6VUgS9K/2u2SAvRjSaCuwIgQu5T07ym0tc dZ8uj2pGTI6NdotihC9gcM3EtoEP+yxCBrLw6TZ13cpoIBnBI3wzy6fl54BjrCbw6+N6 pEMs8PZnENtxx/XuvX2TqZtdwrfSN+ApEjfbof0VOef/RmrxHjC4zENeYEuxHb3qX63K TmpMbf4pjNkF+EoQZlzIUOH74/ZNl0Kbk6nD3v/w47WE7fpJwVbgtGeH3HYJ+pV6SMhC bXeQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782449864; x=1783054664; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=6VsXntDLQe0smfl9QloUZj/9wTE4M6QA+coFCsXtU8Y=; b=gejDzpKzbngb4p7yH4uM+GV9thCfxTNra48hFYniPdCDE6lgM0daAmSrVdJBiaGKUh zpGmolPM5zouihdk4L9/+OCn46fLf2tyHrq6Au6UJw7mWbWRAeoD7cse3f2Xxwq0QJhM 9M1d+vnhJ5dANj7SU9bklKAYPCXYq/1KMhTI4r0/mpmewAqkW4lh4vXpB6m6Pd6Lqfv/ oZhnTQtIQPuvX1fHunq0FKbkHJmuNvAO2fHpsMzDjFFeaSZGAyxXO42LwiGhGYWxiZJf M3nD7xQUK4WlsyaZ6baAVuUdKphYi4lTcviPMOfjw6kBIw/tr65wQEijfYtKFo/q4jJ1 Hy7Q== X-Forwarded-Encrypted: i=1; AFNElJ+uYQZTghV6SFzGF/jpHaLCE+y8OvA6+U4Cl7fI5OI4IyrXOODk9auijWaEm6uhns3njNvY7Xg/78uNho99@lists.postgresql.org X-Gm-Message-State: AOJu0YwKVSQFAxPIW8KA9mTK1lnzZPJkW/xsnDfc1X0IzWgW0shghsA0 8TK7YyCbnuhuu0qO4dIvMqV42dgmQpY4GVQ1v6QS8qtFiW6mZWVrUm5h X-Gm-Gg: AfdE7clZAQkbZCf9MmUjY9Lo/P4jZmMcAJeLJLd9opFfPCvGliLO22XuHT/ECoJ7+Ik homH+y12cuL6sDdl5Qe0YgunzWJ3btxXUpDPZEeQGoKI9A7EQdOyooqTkAzIyY8o63oZ8h7mj2Y FrFee+Ejf+/a6dk2oEbJD7CpEZN2WPVlAVk8DIgaCvPVeuP9B5hZSsR45wsiyaaZujyAWDx4zH5 RWmKnm3XTaDR655D04WzxazdB2V/91srdNL/AL6mT+PuxwSY50vJecEjsRWKulUedpkDSLI9+ky d0yfjRRTRlnAW6kxFobc/A19lgXjYos/3Y8NIi5WibOcVYqjexo18urTH7pdWVbOAFHQ0i+1AHV QKL46tWqrW3IFuHCklxILJC4n/VBFun22ONCvl0lsQt5jNooVpqVvuoHJUSR6akt3X/LwzaJV51 oZ7+OWcoVL01hGNXOhdivcLDSYOTHB4I38wwyTSZiZsiqhWVmeBxmdiGkh+dkS X-Received: by 2002:a05:6a00:1889:b0:845:ca03:9547 with SMTP id d2e1a72fcca58-845ca0398b9mr973230b3a.39.1782449863980; Thu, 25 Jun 2026 21:57:43 -0700 (PDT) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-845a3fec0f7sm5893015b3a.22.2026.06.25.21.57.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 25 Jun 2026 21:57:43 -0700 (PDT) Date: Fri, 26 Jun 2026 13:57:41 +0900 (JST) Message-Id: <20260626.135741.689849099395010573.horikyota.ntt@gmail.com> To: baji.pgdev@gmail.com Cc: zsolt.parragi@percona.com, pgsql-hackers@lists.postgresql.org Subject: Re: uuidv7 improperly accepts dates before 1970-01-01 From: Kyotaro Horiguchi In-Reply-To: References: <20260625.111954.696627555349573162.horikyota.ntt@gmail.com> User-Agent: Mew version 6.8 on Emacs 29.4 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thank you for the new version. At Thu, 25 Jun 2026 08:47:27 -0500, Baji Shaik wrote in > I prefer keeping them as 3 patches since each addresses a distinct > failure mode and is easier to review/bisect independently. That said, > since 0002 and 0003 now share the same errdetail and are logically > the same validation (timestamp outside valid range), I'm happy to > merge them into one patch for v4 if preferred. Personally, I still feel that providing the UUIDv7 timestamp domain in an errdetail is a bit excessive. Even for infinity, I tend to think of the issue as simply being outside the representable range, so I'm not sure that a separate message is necessary. That said, this feels like a matter of taste, so it would probably be useful to hear other opinions. Regards, -- Kyotaro Horiguchi NTT Open Source Software Center