Request a Demo
Home   >   mailing lists

Re: uuidv7 improperly accepts dates before 1970-01-01 - Mailing list pgsql-hackers

From Baji Shaik
Subject Re: uuidv7 improperly accepts dates before 1970-01-01
Date
Msg-id CA+fm-RN23-9h4iHFMVUPyy9N2x05ct2mW3KQ9ZabQPcru9RibQ@mail.gmail.com
Whole thread
In response to Re: uuidv7 improperly accepts dates before 1970-01-01  (Baji Shaik <baji.pgdev@gmail.com>)
List pgsql-hackers
Tree view
On Fri, Jun 12, 2026 at 5:34 PM Baji Shaik <baji.pgdev@gmail.com> wrote:
On Thu, Jun 11, 2026 at 2:20 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
I think we should go ahead and add both upper and lower bound checks,
barring objections.

Thanks Masahiko. Here's a patch series that adds both boundary
checks along with the infinity check from my earlier patch:

  0001 - Reject timestamps before the Unix epoch (lower bound)
  0002 - Reject infinite intervals
  0003 - Reject timestamps beyond the 48-bit field limit (upper bound)

pgsql-hackers by date:

Previous
From: Baji Shaik
Date:
Subject: Re: [PATCH] COPY TO FORMAT json: respect column list order
Next
From: "David E. Wheeler"
Date:
Subject: Re: glob support in extension_control_path/dynamic_library_path?