Re: SQL:2011 application time

From: Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, vignesh C <vignesh21(at)gmail(dot)com>
Subject: Re: SQL:2011 application time
Date: 2025-01-11 23:19:26
Message-ID: 5f0c25de-2c13-4fb5-a4df-a1e03c43cd14@illuminatedcomputing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 1/4/25 13:39, Paul Jungwirth wrote:
> These updates fix a problem in the unaccent contrib module. When I added a new parameter to
> get_func_namespace, I changed a call there. Then I when took out that parameter, I didn't update the
> extension again. Otherwise these are the same as the v46 patches.

Hi Hackers,

Here is another set of commits. Based on discussion on the thread about Index AM API Cleanup [1], I
decided that I should just always make FOR PORTION OF infer its intersect proc from whatever
intersect op is used by temporal foreign keys (even though we don't have a way to get an intersect
op for non-range/multirange types yet). This means we need one less GiST support proc, which seems
like a nice improvement.

I also fixed the RESTRICT commit where a change previously was included in a later commit that
should have been included there.

Rebased to 29dfffae0a, fixing a merge conflict + crash with the NOT ENFORCED commit.

[1]
https://www.postgresql.org/message-id/c1b4f44f-8644-4513-a945-c1c60c79ee28%40illuminatedcomputing.com

Yours,

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

Attachment Content-Type Size
v48-0001-Add-without_portion-GiST-support-proc.patch text/x-patch 41.1 KB
v48-0002-Fix-NOACTION-temporal-foreign-keys-when-the-refe.patch text/x-patch 23.8 KB
v48-0003-Fix-RESTRICT-temporal-foreign-keys-when-the-refe.patch text/x-patch 30.5 KB
v48-0004-Add-UPDATE-DELETE-FOR-PORTION-OF.patch text/x-patch 203.9 KB
v48-0005-Add-CASCADE-SET-NULL-SET-DEFAULT-for-temporal-fo.patch text/x-patch 201.0 KB
v48-0006-Expose-FOR-PORTION-OF-to-plpgsql-triggers.patch text/x-patch 13.2 KB
v48-0007-Add-PERIODs.patch text/x-patch 591.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2025-01-11 23:33:35 Re: llvm dependency and space concerns
Previous Message Sami Imseih 2025-01-11 22:50:29 Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch)