Re: Problem with transition tables on partitioned tables with foreign-table partitions

2025-07-14 Thread Etsuro Fujita
Amit-san, On Thu, Jul 10, 2025 at 11:54 PM Amit Langote wrote: > On Thu, Jul 10, 2025 at 22:20 Amit Langote wrote: >> On Wed, Jul 9, 2025 at 5:07 PM Etsuro Fujita wrote: >> > Here is an updated version of the patch, in which I added 1) an Assert >> > to ExecAR* functions to ensure that the pass

Re: Problem with transition tables on partitioned tables with foreign-table partitions

2025-07-10 Thread Amit Langote
On Thu, Jul 10, 2025 at 22:20 Amit Langote wrote: > Fujita-san, > > On Wed, Jul 9, 2025 at 5:07 PM Etsuro Fujita > wrote: > > On Tue, Jul 1, 2025 at 11:55 AM Etsuro Fujita > wrote: > > > So I would > > > like to propose to fix this by the following: 1) disable using direct > > > modify to modif

Re: Problem with transition tables on partitioned tables with foreign-table partitions

2025-07-10 Thread Amit Langote
Fujita-san, On Wed, Jul 9, 2025 at 5:07 PM Etsuro Fujita wrote: > On Tue, Jul 1, 2025 at 11:55 AM Etsuro Fujita 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 trig

Re: Problem with transition tables on partitioned tables with foreign-table partitions

2025-07-09 Thread Etsuro Fujita
On Tue, Jul 1, 2025 at 11:55 AM Etsuro Fujita 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 > ExecARInse

Re: Problem with transition tables on partitioned tables with foreign-table partitions

2025-07-02 Thread Etsuro Fujita
On Wed, Jul 2, 2025 at 10:05 PM Amit Langote wrote: > On Wed, Jul 2, 2025 at 7:05 PM Etsuro Fujita wrote: > > On Tue, Jul 1, 2025 at 4:42 PM Amit Langote wrote: > > > On Tue, Jul 1, 2025 at 11:55 AM Etsuro Fujita > > > wrote: > > > > While working on something else, I noticed that while we dis

Re: Problem with transition tables on partitioned tables with foreign-table partitions

2025-07-02 Thread Amit Langote
On Wed, Jul 2, 2025 at 7:05 PM Etsuro Fujita wrote: > On Tue, Jul 1, 2025 at 4:42 PM Amit Langote wrote: > > On Tue, Jul 1, 2025 at 11:55 AM Etsuro Fujita > > wrote: > > > While working on something else, I noticed that while we disallow > > > transition tables on foreign tables, we allow trans

Re: Problem with transition tables on partitioned tables with foreign-table partitions

2025-07-02 Thread Etsuro Fujita
Hi Amit-san, On Tue, Jul 1, 2025 at 4:42 PM Amit Langote wrote: > On Tue, Jul 1, 2025 at 11:55 AM Etsuro Fujita wrote: > > While working on something else, I noticed that while we disallow > > transition tables on foreign tables, we allow transition tables on > > partitioned tables with foreign-

Re: Problem with transition tables on partitioned tables with foreign-table partitions

2025-07-01 Thread Amit Langote
Hi Fujita-san, On Tue, Jul 1, 2025 at 11:55 AM Etsuro Fujita wrote: > > Hi, > > While working on something else, I noticed that while we disallow > transition tables on foreign tables, we allow transition tables on > partitioned tables with foreign-table partitions, which produces > incorrect res

Problem with transition tables on partitioned tables with foreign-table partitions

2025-06-30 Thread Etsuro Fujita
Hi, While working on something else, I noticed that while we disallow transition tables on foreign tables, we allow transition tables on partitioned tables with foreign-table partitions, which produces incorrect results. Here is an example using postgres_fdw: create table parent (a text, b int)