Re: BUG #16631: postgres_fdw tries to insert into generated columns - Mailing list pgsql-bugs

From Etsuro Fujita
Subject Re: BUG #16631: postgres_fdw tries to insert into generated columns
Date
Msg-id CAPmGK1732jc4iTfLg3K-6hwsedw4rt2j-BQ9n5tv+6nKUkySYw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16631: postgres_fdw tries to insert into generated columns  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-bugs
On Wed, Jul 7, 2021 at 5:45 PM Peter Eisentraut
<peter.eisentraut@enterprisedb.com> wrote:
> On 07.07.21 09:20, Etsuro Fujita wrote:
> > * Modified nodeModifyTable.c and copyfrom.c so that they don't compute
> > generated columns for FDWs anymore.
>
> I don't agree with that change.  What is the point of declaring a
> generated column on a foreign table if you ignore it?  Then you might as
> well prohibit declaring such columns in the first place.

I made that change as FDWs could call ExecComputeStoredGenerated() by
themselves if necessary.  I think that that would be consistent with
the constraint case.

Best regards,
Etsuro Fujita



pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #16631: postgres_fdw tries to insert into generated columns
Next
From: David Rowley
Date:
Subject: Re: BUG #17089: "ERROR: invalid memory alloc request size ..." occurs when updating a fixed number of records