Re: Protect against timestamp underflow in uuidv7(interval)

[Baji Shaik]

On Tue, Jun 23, 2026 at 6:39 PM Tristan Partin <tris...@partin.io> wrote:

> We were silently allowing underflowing the generated timestamp for the
> UUIDv7 value:
>
>         # SELECT uuid_extract_timestamp(uuidv7('-57 years'::interval));
>            uuid_extract_timestamp
>         -----------------------------
>          10889-01-23 04:02:36.375+00
>         (1 row)
>

Thank you, Tristan.
This has been reported and is being discussed here [1]

[1]:
https://www.postgresql.org/message-id/CA%2Bfm-RN4eMEr2tzZU_mAV-%3DWfdmPXJ4Ea_GpmSS8%3DyStSy8onQ%40mail.gmail.com

Thanks,
Baji Shaik.