Re: SQL:2011 Application Time Update & Delete

From: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>
Subject: Re: SQL:2011 Application Time Update & Delete
Date: 2025-10-13 06:43:20
Message-ID: CA+renyWcNBdnaW4zc9S03aN+fEbVVB1S+q8e9MEjhM2YB+kkiw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Oct 4, 2025 at 12:48 PM Paul A Jungwirth
<pj(at)illuminatedcomputing(dot)com> wrote:
>
> On Wed, Sep 24, 2025 at 9:05 PM Paul A Jungwirth
> <pj(at)illuminatedcomputing(dot)com> wrote:
> >
> > Here is another update, now with working PERIOD DDL. I also fixed some
> > new post-rebase problems causing CI to fail.
>
> More rebase & CI fixes attached.
>
> Rebased to 03d40e4b52 now.

It looks like an #include I needed went away and my patches stopped
compiling. Here is a new series.

Now rebased to 7a662a46eb.

Yours,

--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com

Attachment Content-Type Size
v56-0003-Document-temporal-PERIODs.patch text/x-patch 1.9 KB
v56-0005-Add-range_minus_multi-and-multirange_minus_multi.patch text/x-patch 22.7 KB
v56-0001-Add-docs-chapter-for-temporal-tables.patch text/x-patch 17.7 KB
v56-0004-Document-temporal-update-delete.patch text/x-patch 23.8 KB
v56-0002-Document-temporal-foreign-keys.patch text/x-patch 9.6 KB
v56-0010-Expose-FOR-PORTION-OF-to-plpgsql-triggers.patch text/x-patch 14.5 KB
v56-0006-Add-UPDATE-DELETE-FOR-PORTION-OF.patch text/x-patch 200.7 KB
v56-0008-Look-up-more-temporal-foreign-key-helper-procs.patch text/x-patch 6.8 KB
v56-0007-Add-tg_temporal-to-TriggerData.patch text/x-patch 10.3 KB
v56-0009-Add-CASCADE-SET-NULL-SET-DEFAULT-for-temporal-fo.patch text/x-patch 205.8 KB
v56-0011-Add-PERIODs.patch text/x-patch 564.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2025-10-13 06:59:59 Re: Logical Replication of sequences
Previous Message Bertrand Drouvot 2025-10-13 06:27:25 Re: Question about InvalidatePossiblyObsoleteSlot()