Re: SQL:2011 application time

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>
Subject: Re: SQL:2011 application time
Date: 2024-05-15 09:39:47
Message-ID: d0b64a7a-dfe4-4b84-a906-c7dedfa40a3e@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 15.05.24 08:13, Michael Paquier wrote:
> On Tue, May 14, 2024 at 01:33:46PM +0800, jian he wrote:
>> thanks for the idea, I roughly played around with it, seems doable.
>> but the timing seems not good, reverting is a good idea.
>
> Please note that this is still an open item, and that time is running
> short until beta1. A revert seems to be the consensus reached, so,
> Peter, are you planning to do so?

I'm on it.

Here is the list of patches I have identified to revert:

git show --oneline --no-patch 144c2ce0cc7 c3db1f30cba 482e108cd38
34768ee3616 5577a71fb0c a88c800deb6 030e10ff1a3 86232a49a43 46a0cd4cefb
6db4598fcb8

144c2ce0cc7 Fix ON CONFLICT DO NOTHING/UPDATE for temporal indexes
c3db1f30cba doc: clarify PERIOD and WITHOUT OVERLAPS in CREATE TABLE
482e108cd38 Add test for REPLICA IDENTITY with a temporal key
34768ee3616 Add temporal FOREIGN KEY contraints
5577a71fb0c Use half-open interval notation in without_overlaps tests
a88c800deb6 Use daterange and YMD in without_overlaps tests instead of
tsrange.
030e10ff1a3 Rename pg_constraint.conwithoutoverlaps to conperiod
86232a49a43 Fix comment on gist_stratnum_btree
46a0cd4cefb Add temporal PRIMARY KEY and UNIQUE constraints
6db4598fcb8 Add stratnum GiST support function

Attached are the individual revert patches. I'm supplying these here
mainly so that future efforts can use those instead of the original
patches, since that would have to redo all the conflict resolution and
also miss various typo fixes etc. that were applied in the meantime. I
will commit this as one squashed patch.

Attachment Content-Type Size
0001-Revert-Fix-ON-CONFLICT-DO-NOTHING-UPDATE-for-tempora.patch text/plain 20.3 KB
0002-Revert-doc-clarify-PERIOD-and-WITHOUT-OVERLAPS-in-CR.patch text/plain 1.8 KB
0003-Revert-Add-test-for-REPLICA-IDENTITY-with-a-temporal.patch text/plain 1.6 KB
0004-Revert-Add-temporal-FOREIGN-KEY-contraints.patch text/plain 167.3 KB
0005-Revert-Use-half-open-interval-notation-in-without_ov.patch text/plain 9.3 KB
0006-Revert-Use-daterange-and-YMD-in-without_overlaps-tes.patch text/plain 14.7 KB
0007-Revert-Rename-pg_constraint.conwithoutoverlaps-to-co.patch text/plain 11.4 KB
0008-Revert-Fix-comment-on-gist_stratnum_btree.patch text/plain 826 bytes
0009-Revert-Add-temporal-PRIMARY-KEY-and-UNIQUE-constrain.patch text/plain 74.7 KB
0010-Revert-Add-stratnum-GiST-support-function.patch text/plain 20.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2024-05-15 09:49:22 Re: Postgres and --config-file option
Previous Message Alvaro Herrera 2024-05-15 09:14:14 Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM