Re: Problem with transition tables on partitioned tables with foreign-table partitions - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Problem with transition tables on partitioned tables with foreign-table partitions
Date
Msg-id CAPmGK17yFaWi74ti4kt31iSE+cM6fd_hyW5qgRz=zXnFe9Ywag@mail.gmail.com
Whole thread Raw
In response to Problem with transition tables on partitioned tables with foreign-table partitions  (Etsuro Fujita <etsuro.fujita@gmail.com>)
List pgsql-hackers
On Tue, Jul 1, 2025 at 11:55 AM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:
> So I would
> like to propose to fix this by the following: 1) disable using direct
> modify to modify foreign-table partitions if there are any
> transition-table triggers on the partitioned table, and then 2) throw
> an error in ExecARInsertTriggers()/ExecARUpdateTriggers()/ExecARDeleteTriggers()
> if they collects transition tuple(s) from a foreign-table partition.
>
> Attached is a WIP patch for that.

Here is an updated version of the patch, in which I added 1) an Assert
to ExecAR* functions to ensure that the passed-in ResultRelInfo
pointer is not NULL, 2) added/tweaked comments a bit more, and 3)
added regression tests.

Best regards,
Etsuro Fujita

Attachment

pgsql-hackers by date:

Previous
From: Alexandra Wang
Date:
Subject: Re: SQL:2023 JSON simplified accessor support
Next
From: Bertrand Drouvot
Date:
Subject: Re: Adding basic NUMA awareness - Preliminary feedback and outline for an extensible approach