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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wcZiD-003SWh-0T
	for pgsql-hackers@arkaria.postgresql.org;
	Thu, 25 Jun 2026 02:21:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wcZhC-003J4T-0f
	for pgsql-hackers@arkaria.postgresql.org;
	Thu, 25 Jun 2026 02:20:02 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <horikyota.ntt@gmail.com>)
	id 1wcZhB-003J4L-2o
	for pgsql-hackers@lists.postgresql.org;
	Thu, 25 Jun 2026 02:20:01 +0000
Received: from mail-pf1-x432.google.com ([2607:f8b0:4864:20::432])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <horikyota.ntt@gmail.com>)
	id 1wcZh9-000000007nG-1jK2
	for pgsql-hackers@lists.postgresql.org;
	Thu, 25 Jun 2026 02:20:01 +0000
Received: by mail-pf1-x432.google.com with SMTP id
 d2e1a72fcca58-842848fd613so1389994b3a.3
        for <pgsql-hackers@lists.postgresql.org>;
 Wed, 24 Jun 2026 19:19:58 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20251104; t=1782353997; x=1782958797;
 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=eQR1cM7DXOihilKzzQ1hdGCseRfPIs2oriu1mf1E+MY=;
        b=Oz8pqwwlq3bExCvOQJGMJZLbfRtFsZ9i4/KEOKW6KwFlrlf5YiZjIyMhE3qQ0jxULW
         OG74SYHxVjxAiC0c5ptA8QAemHHw+0kGFphUY7MlBeIOsKFFnT4IPGvYVtYyYbvHutUE
         3Sv9DQqX4xjSIwjufnwyI/ffzl2Y+PKrIH1xt2k2t3Kug7r8QVHBBuhWDNUggXueSPuN
         1ABcj6Mev3a5ojlvs3VcELkimMudNpzw2JdpNiX1SXHoqFxqp8+DNZk8uCVpPADlAE54
         JipWfIo7pyvEXZfE72OVwGROqkX9Aweiqy42mZX9fpDV9Qun8GacofwQZRg6Zay52QrY
         QzhA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1782353997; x=1782958797;
        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=eQR1cM7DXOihilKzzQ1hdGCseRfPIs2oriu1mf1E+MY=;
        b=tRfGKw5Pt5/9YS3lSeE9hOEFznO1wNIorCGkj9NsCko/Xwaovaj7YbRbRi6FVuqwX2
         q1EO9isGzOYD3yZHd4NlMWD88PVYfkC9EIE/S1wK7TBVMiN8bRon1o5P8wyPnaq+j1bP
         JDKeCPAUkcnTmLjcrKW/40aanpkYKbNxdMMu/ndWd4f7XI6WPCu1H5srXxZzyyY07KgO
         yHnHL6lbr9LHNGkVAyP93pNIXlRYzJ9IAke3QJAbc7EtUFSbwgZFd8va/XcfTpXCEl0Y
         W1QYuESv/fFc0XA8xGLu5/de78638LMYYjj0i5vC2/xvbilFDVfD4SnS+S1dg9iBLNx6
         bwYw==
X-Forwarded-Encrypted: i=1;
 AHgh+RqeOUgwqbnhLXlDn77n/+oQnpHvjFBc6itiQYpJthh6S6g9gCwapnfi0p6s6Jcj7nNWwtOdCkAEd6Arb2Cm@lists.postgresql.org
X-Gm-Message-State: AOJu0YzyWmyQQeDbRz2Md1lkJ55zuEhvT45hFFF8qWqIwQVZgtIBw2o6
	J/IsKFe6XoKJ1obbTQaVQgNoC4s+Vh5ulNRjOMQLYwwbWXBMHz1AjIDV
X-Gm-Gg: AfdE7cmheiE7yCTwTWy+RKSBjmFntmfWl2WTGSyk5uw5qg9QATePfdxtNWZmGoEt5f+
	wcgADzbtrW/pk45hGeohSd0Ec3zUUbTs73/lvIY5uLIADAox1bLFe9dwhblqq4O89w+o++iFqO4
	PjN4ShyFgydNzFB8cspWFdkcb3jxCBy7BPgRyCk0R69bQbs3DDKQs6feB3YwMW4g8O0Cdq86+oX
	h5wPninRglb43xVxsLCATWYwU36r981jPezDc5tFaeTlDvHEJFtHK6gYSuFRFIHSsr6Ki6z0IVl
	zKr6m1JweYnzP+glLTI40GvlWfuYyyXirEnX9JgcmZKkMVf1PPR7m7tuSqDaOvvt6908ezW5902
	t7KPeDaD+Qw28ej/jn3xAlhgD5WEdDryjuU3auVHBBwLhhfE+PKUd/gBMfWvpPUd2//ny+Ai0PC
	2PRwXEMAnRB+C9ZbHcKcNn3T96NmiCD6FuN9dcQtHC931w+sA5ztDhyEYJqs9z
X-Received: by 2002:a05:6a00:ad06:b0:842:6a97:52f7 with SMTP id
 d2e1a72fcca58-845b3a1a1f5mr918340b3a.19.1782353996839;
        Wed, 24 Jun 2026 19:19:56 -0700 (PDT)
Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111])
        by smtp.gmail.com with ESMTPSA id
 d2e1a72fcca58-845a40d2341sm3544367b3a.39.2026.06.24.19.19.55
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Wed, 24 Jun 2026 19:19:56 -0700 (PDT)
Date: Thu, 25 Jun 2026 11:19:54 +0900 (JST)
Message-Id: <20260625.111954.696627555349573162.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 <horikyota.ntt@gmail.com>
In-Reply-To: 
 <CA+fm-RPjp8fC-w50PApyhrfMqY4SA0zT5s1Nq=+03+ALcf+3+A@mail.gmail.com>
References: 
 <CA+fm-RN4eMEr2tzZU_mAV-=WfdmPXJ4Ea_GpmSS8=yStSy8onQ@mail.gmail.com>
	<CAN4CZFP9XsTXijqxtK7v9Hgad3jQN-m+wBve0azdi3QkheJv7Q@mail.gmail.com>
	<CA+fm-RPjp8fC-w50PApyhrfMqY4SA0zT5s1Nq=+03+ALcf+3+A@mail.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: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/20260625.111954.696627555349573162.horikyota.ntt%40gmail.com>
Precedence: bulk

Hello,

At Wed, 24 Jun 2026 18:22:20 -0500, Baji Shaik <baji.pgdev@gmail.com> wrote in 
> Let me know if I have missed anything.

The checks themselves seem reasonable to me. However, I do have one
comment about the error reporting.

The checks themselves seem reasonable to me. However, I'm not sure the
various cases need separate error messages.