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 1wcTnl-003Nhn-11
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 24 Jun 2026 20:02:25 +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 1wcTnj-002HMo-2I
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 24 Jun 2026 20:02:23 +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 <xof@thebuild.com>)
	id 1wcTnj-002HMg-1G
	for pgsql-hackers@lists.postgresql.org;
	Wed, 24 Jun 2026 20:02:23 +0000
Received: from smtp113.iad3a.emailsrvr.com ([173.203.187.113])
	by makus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <xof@thebuild.com>)
	id 1wcTnh-000000004lD-0kAa
	for pgsql-hackers@lists.postgresql.org;
	Wed, 24 Jun 2026 20:02:22 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=g001.emailsrvr.com;
	s=feedback; t=1782331340;
	bh=HrP5ojQw7JEUSIPLt77u2RPeZIMiOpoLMB++mQmW8xc=;
	h=Subject:From:Date:To:From;
	b=X+G3JxJSEYs41pkU3/hfD0b0fZcRmtvfOdASG39AH4DUM619tVm1y4es3q+BET3Ud
	 LE0iOsGzb1rj6ukVlfb6qjefENTSG+4OdJKdq8Hm0gy1f3f2g0rlaAaKWSmSD5mzig
	 IFdSnvE/kSWP6BDr0aqmTXgLHoWe6+xRuIUNgIrE=
X-Auth-ID: xof@thebuild.com
Received: by smtp15.relay.iad3a.emailsrvr.com (Authenticated sender:
 xof-AT-thebuild.com) with ESMTPSA id BF3A357F7;
	Wed, 24 Jun 2026 16:02:19 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.12\))
Subject: Re: uuidv7 improperly accepts dates before 1970-01-01
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: 
 <CAD21AoBpCg6u8wzQ3hGLbxsrn6sBkkdBXuZkgpEH+rZRSxLn6g@mail.gmail.com>
Date: Wed, 24 Jun 2026 13:02:18 -0700
Cc: Andrey Borodin <x4mmm@yandex-team.ru>,
 pgsql-hackers@lists.postgresql.org,
 Masahiko Sawada <sawada.mshk@gmail.com>
Content-Transfer-Encoding: quoted-printable
Message-Id: <18F007D6-1A33-48C8-BA51-E7A858DE0C89@thebuild.com>
References: <799A70FA-6E5C-4118-99EB-2FBBE1CBAC54@thebuild.com>
 <966B5430-8ECD-48FA-B56F-22452D9CDBBF@yandex-team.ru>
 <E3B0C0EF-E9F3-4DCE-9F36-0C048E1D46D6@thebuild.com>
 <CAD21AoAJN-Yb1mP5W-95UWQNMPgcE6OzCyJLKJRqTRrU5WxH5Q@mail.gmail.com>
 <CA+fm-ROd4cNKM524n6EdgtZ9xOzOHJDNv8J_9Mvr2+2t1qWSDw@mail.gmail.com>
 <CAD21AoBpxjp3wjQ4dia0c76Bp8E=Q4UOgBTU4ZOn3Sj6k=-SsA@mail.gmail.com>
 <CA+fm-RN4eMEr2tzZU_mAV-=WfdmPXJ4Ea_GpmSS8=yStSy8onQ@mail.gmail.com>
 <CAD21AoBpCg6u8wzQ3hGLbxsrn6sBkkdBXuZkgpEH+rZRSxLn6g@mail.gmail.com>
To: Baji Shaik <baji.pgdev@gmail.com>
X-Mailer: Apple Mail (2.3776.700.51.11.12)
X-Classification-ID: 936f88db-1654-4bc6-803d-977103b483b4-1-1
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/18F007D6-1A33-48C8-BA51-E7A858DE0C89%40thebuild.com>
Precedence: bulk



> On Jun 24, 2026, at 10:46, Masahiko Sawada <sawada.mshk@gmail.com> =
wrote:
> I think we need to mention in the doc that timestamp shifting beyond
> the range UUIDv7 can support is not accepted.

I believe the doc patch in my original patch included that admonition.  =
Please feel free to grab it if you'd like.