Request a Demo
Home   >   mailing lists

Re: Protect against timestamp underflow in uuidv7(interval) - Mailing list pgsql-hackers

From Baji Shaik
Subject Re: Protect against timestamp underflow in uuidv7(interval)
Date
Msg-id CA+fm-RPUtUqR90-jBtKkQY_xtgdoA64Q=-Bgi8+o-fiYA5ZxmQ@mail.gmail.com
Whole thread
In response to Protect against timestamp underflow in uuidv7(interval)  ("Tristan Partin" <tristan@partin.io>)
List pgsql-hackers
Tree view
On Tue, Jun 23, 2026 at 6:39 PM Tristan Partin <tristan@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.

Thanks,
Baji Shaik. 

pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: Why clearing the VM doesn't require registering vm buffer in wal record
Next
From: Melanie Plageman
Date:
Subject: Re: Why clearing the VM doesn't require registering vm buffer in wal record