| From: | Baji Shaik <baji(dot)pgdev(at)gmail(dot)com> |
|---|---|
| To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Cc: | Christophe Pettus <xof(at)thebuild(dot)com>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: uuidv7 improperly accepts dates before 1970-01-01 |
| Date: | 2026-06-24 15:25:11 |
| Message-ID: | CA+fm-RN23-9h4iHFMVUPyy9N2x05ct2mW3KQ9ZabQPcru9RibQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Fri, Jun 12, 2026 at 5:34 PM Baji Shaik <baji(dot)pgdev(at)gmail(dot)com> wrote:
> On Thu, Jun 11, 2026 at 2:20 PM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)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)
>
Added to the commitfest: https://commitfest.postgresql.org/patch/6935/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Etsuro Fujita | 2026-06-24 17:02:41 | Re: BUG #19484: Segmentation fault triggered by FDW |
| Previous Message | Tom Lane | 2026-06-24 14:57:58 | Re: BUG #19483: pg_upgrade fails with orphan records in pg_init_priv catalog table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David E. Wheeler | 2026-06-24 15:34:29 | Re: glob support in extension_control_path/dynamic_library_path? |
| Previous Message | Baji Shaik | 2026-06-24 15:22:14 | Re: [PATCH] COPY TO FORMAT json: respect column list order |