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

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: uuidv7 improperly accepts dates before 1970-01-01
Date: 2026-07-03 19:54:14
Message-ID: CAN4CZFOupdhpOwOJBKpG2F4tJ6WgmoNHMXSAwOZXV=6SpVb_yw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs 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"?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Baji Shaik 2026-07-03 23:54:16 Re: uuidv7 improperly accepts dates before 1970-01-01
Previous Message Tom Lane 2026-07-03 19:36:09 Re: Fw:Re: Fw: gbt_var_consistent in contrib/btree_gist/btree_utils_var.c has internal-node type confusion on the <> strategy, bypassing exclusion constraints

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2026-07-03 20:17:31 Re: Coverage (lcov) failing with inconsistent error in versions 2.x
Previous Message Andrey Borodin 2026-07-03 19:14:36 Re: [GSoC 2026] - B-tree Index Bloat Reduction - Approach & Questions