Horton
Menu

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

Kyotaro Horiguchi <horikyota.ntt@gmail.com>

View thread
From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
To: baji.pgdev@gmail.com
Cc: zsolt.parragi@percona.com, pgsql-hackers@lists.postgresql.org
Date: 2026-06-25T02:19:54Z
Lists: pgsql-bugs, pgsql-hackers 
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.

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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. COPY TO FORMAT JSON: respect column list order