Horton
Menu

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

Christophe Pettus <xof@thebuild.com>

View thread
From: Christophe Pettus <xof@thebuild.com>
To: Baji Shaik <baji.pgdev@gmail.com>
Cc: Andrey Borodin <x4mmm@yandex-team.ru>, pgsql-hackers@lists.postgresql.org, Masahiko Sawada <sawada.mshk@gmail.com>
Date: 2026-06-24T20:02:18Z
Lists: pgsql-bugs, pgsql-hackers 

> On Jun 24, 2026, at 10:46, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> I think we need to mention in the doc that timestamp shifting beyond
> the range UUIDv7 can support is not accepted.

I believe the doc patch in my original patch included that admonition.  Please feel free to grab it if you'd like.

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