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

Baji Shaik <baji.pgdev@gmail.com>

View thread

From: Baji Shaik <baji.pgdev@gmail.com>

To: Zsolt Parragi <zsolt.parragi@percona.com>

Cc: pgsql-hackers@lists.postgresql.org

Date: 2026-07-03T23:54:16Z

Lists: pgsql-hackers

Attachments

v5-0002-Reject-out-of-range-timestamps-in-uuidv7-interval.patch (application/octet-stream) patch v5-0002
v5-0001-Reject-infinite-intervals-in-uuidv7-interval.patch (application/octet-stream) patch v5-0001

On Fri, Jul 3, 2026 at 2:54 PM Zsolt Parragi <zsolt.parragi@percona.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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

COPY TO FORMAT JSON: respect column list order
- effb923d9dec 19 (unreleased) landed