Re: SQL:2011 Application Time Update & Delete

Paul A Jungwirth <pj@illuminatedcomputing.com>

View thread

From: Paul A Jungwirth <pj@illuminatedcomputing.com>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter@eisentraut.org>

Date: 2025-10-13T06:43:20Z

Lists: pgsql-hackers

Attachments

v56-0003-Document-temporal-PERIODs.patch (text/x-patch) patch v56-0003
v56-0005-Add-range_minus_multi-and-multirange_minus_multi.patch (text/x-patch) patch v56-0005
v56-0001-Add-docs-chapter-for-temporal-tables.patch (text/x-patch) patch v56-0001
v56-0004-Document-temporal-update-delete.patch (text/x-patch) patch v56-0004
v56-0002-Document-temporal-foreign-keys.patch (text/x-patch) patch v56-0002
v56-0010-Expose-FOR-PORTION-OF-to-plpgsql-triggers.patch (text/x-patch) patch v56-0010
v56-0006-Add-UPDATE-DELETE-FOR-PORTION-OF.patch (text/x-patch) patch v56-0006
v56-0008-Look-up-more-temporal-foreign-key-helper-procs.patch (text/x-patch) patch v56-0008
v56-0007-Add-tg_temporal-to-TriggerData.patch (text/x-patch) patch v56-0007
v56-0009-Add-CASCADE-SET-NULL-SET-DEFAULT-for-temporal-fo.patch (text/x-patch) patch v56-0009
v56-0011-Add-PERIODs.patch (text/x-patch) patch v56-0011

On Sat, Oct 4, 2025 at 12:48 PM Paul A Jungwirth
<pj@illuminatedcomputing.com> wrote:
>
> On Wed, Sep 24, 2025 at 9:05 PM Paul A Jungwirth
> <pj@illuminatedcomputing.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@illuminatedcomputing.com

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Make ExecForPortionOfLeftovers() obey SRF protocol.
- 207cb2abcba0 19 (unreleased) landed
Add isolation tests for UPDATE/DELETE FOR PORTION OF
- b6ccd30d8ff6 19 (unreleased) landed
Add UPDATE/DELETE FOR PORTION OF
- 8e72d914c528 19 (unreleased) landed
Record range constructor functions in pg_range
- c257ba839718 19 (unreleased) landed
Add range_minus_multi and multirange_minus_multi functions
- 5eed8ce50ce9 19 (unreleased) landed
doc: Add section for temporal tables
- e4d8a2af07f5 19 (unreleased) landed
Add assertion check for WAL receiver state during stream-archive transition
- 65f4976189b6 19 (unreleased) cited