Re: uuidv7 improperly accepts dates before 1970-01-01 - Mailing list pgsql-hackers

From Kyotaro Horiguchi
Subject Re: uuidv7 improperly accepts dates before 1970-01-01
Date
Msg-id 20260625.111954.696627555349573162.horikyota.ntt@gmail.com
Whole thread
In response to Re: uuidv7 improperly accepts dates before 1970-01-01  (Baji Shaik <baji.pgdev@gmail.com>)
Responses Re: uuidv7 improperly accepts dates before 1970-01-01
List 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



pgsql-hackers by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: 035_standby_logical_decoding might fail due to FATAL message lost inside libpq
Next
From: Chao Li
Date:
Subject: doc: fix pg_stat_autovacuum_scores threshold wording