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

From: Baji Shaik <baji(dot)pgdev(at)gmail(dot)com>
To: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: uuidv7 improperly accepts dates before 1970-01-01
Date: 2026-07-03 23:54:16
Message-ID: CA+fm-RPAMxA_+h5q=_TShnQ9dooD8OLsebeBsSnsH2GOi+HtTw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Fri, Jul 3, 2026 at 2:54 PM Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
wrote:

> There's no overflow anymore with the current patch, so that comment is
> somewhat stale. Maybe it could be simply "large future intervals are
> rejected"?
>

Thanks Zsolt! Good catch. Updated the test comment in v5 attached.

Thanks,
Baji Shaik

Attachment Content-Type Size
v5-0002-Reject-out-of-range-timestamps-in-uuidv7-interval.patch application/octet-stream 6.0 KB
v5-0001-Reject-infinite-intervals-in-uuidv7-interval.patch application/octet-stream 3.2 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2026-07-03 23:57:23 Re: BUG #19533: Wrong results from WindowAgg run-condition pushdown on count() with EXCLUDE CURRENT ROW
Previous Message Zsolt Parragi 2026-07-03 19:54:14 Re: uuidv7 improperly accepts dates before 1970-01-01

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2026-07-04 00:38:53 Re: Can we get rid of TerminateThread() in pg_dump?
Previous Message Dean Rasheed 2026-07-03 23:37:12 Re: Global temporary tables