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 20260626.135741.689849099395010573.horikyota.ntt@gmail.com
Whole thread
In response to Re: uuidv7 improperly accepts dates before 1970-01-01  (Baji Shaik <baji.pgdev@gmail.com>)
List pgsql-hackers
Thank you for the new version.

At Thu, 25 Jun 2026 08:47:27 -0500, Baji Shaik <baji.pgdev@gmail.com> wrote in 
> I prefer keeping them as 3 patches since each addresses a distinct
> failure mode and is easier to review/bisect independently. That said,
> since 0002 and 0003 now share the same errdetail and are logically
> the same validation (timestamp outside valid range), I'm happy to
> merge them into one patch for v4 if preferred.

Personally, I still feel that providing the UUIDv7 timestamp domain in
an errdetail is a bit excessive. Even for infinity, I tend to think of
the issue as simply being outside the representable range, so I'm not
sure that a separate message is necessary.

That said, this feels like a matter of taste, so it would probably be
useful to hear other opinions.

Regards,

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: JoongHyuk Shin
Date:
Subject: Re: [PATCH] Prevent repeated deadlock-check signals in standby buffer pin waits
Next
From: vignesh C
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication