Re: uuidv7 improperly accepts dates before 1970-01-01

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Baji Shaik <baji(dot)pgdev(at)gmail(dot)com>
Cc: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Subject: Re: uuidv7 improperly accepts dates before 1970-01-01
Date: 2026-06-24 20:02:18
Message-ID: 18F007D6-1A33-48C8-BA51-E7A858DE0C89@thebuild.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

> On Jun 24, 2026, at 10:46, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Zsolt Parragi 2026-06-24 20:31:53 Re: uuidv7 improperly accepts dates before 1970-01-01
Previous Message Tristan Partin 2026-06-24 17:58:02 Re: uuidv7 improperly accepts dates before 1970-01-01

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2026-06-24 20:06:55 Re: [PATCH] Fix sequence value may rollback after CREATE DATABASE TEMPLATE with WAL_LOG strategy
Previous Message Jelte Fennema-Nio 2026-06-24 19:48:20 Re: pg_get__*_ddl consolidation