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

From Tom Lane
Subject Re: BUG #16631: postgres_fdw tries to insert into generated columns
Date
Msg-id 1838679.1625673259@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #16631: postgres_fdw tries to insert into generated columns  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: BUG #16631: postgres_fdw tries to insert into generated columns  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #17088: FailedAssertion in prepagg.c
Next
From: PG Bug reporting form
Date:
Subject: BUG #17091: Cannot install with EDB installer when username contains diacritics