Re: BUG #16631: postgres_fdw tries to insert into generated columns

Peter Eisentraut <peter.eisentraut@enterprisedb.com> writes:
> 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.

Maybe what we need here is some documentation clarifying exactly what
the point of a generated column on a foreign table actually *is*.
When would you do it, and what relationship if any has it got to the
generation status of the underlying remote column?

            regards, tom lane