Horton
Menu

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

Zsolt Parragi <zsolt.parragi@percona.com>

View thread
From: Zsolt Parragi <zsolt.parragi@percona.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2026-07-03T19:54:14Z
Lists: pgsql-hackers 
v4 looks good to me, I only have one completely optional nitpick comment:

+-- uuidv7: large future intervals that overflow epoch conversion are rejected
+SELECT uuidv7('292230 years'::interval);
+

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"?

Commits

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

  1. COPY TO FORMAT JSON: respect column list order