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

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: baji(dot)pgdev(at)gmail(dot)com
Cc: zsolt(dot)parragi(at)percona(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: uuidv7 improperly accepts dates before 1970-01-01
Date: 2026-06-25 02:19:54
Message-ID: 20260625.111954.696627555349573162.horikyota.ntt@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hello,

At Wed, 24 Jun 2026 18:22:20 -0500, Baji Shaik <baji(dot)pgdev(at)gmail(dot)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.

From a user's perspective, it seems sufficient to know that the
shifted timestamp falls outside the range supported by UUID v7. As a
translator, I'm not particularly enthusiastic about adding more
message variants when the distinction is not particularly useful to
users.

Regards,

--
Kyotaro Horiguchi
NTT Open Source Software Center

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-06-25 02:44:23 doc: fix pg_stat_autovacuum_scores threshold wording
Previous Message Hayato Kuroda (Fujitsu) 2026-06-25 02:04:23 RE: 035_standby_logical_decoding might fail due to FATAL message lost inside libpq

Browse pgsql-bugs by date

  From Date Subject
Previous Message surya poondla 2026-06-24 23:56:10 Re: Two bugs around ALTER TYPE