On 2019-04-01 10:52, Peter Eisentraut wrote: > On 2019-03-31 05:49, Erik Rijkers wrote: >> STORED in a >> file_fdw foreign table still silently creates the column which then >> turns out to be useless on SELECT, with an error like: >> >> "ERROR: column some_column_name is a generated column >> DETAIL: Generated columns cannot be used in COPY." >> >> Maybe it'd be possible to get an error earlier, i.e., while trying to >> create such a useless column? > > I'll look into it.
I've been trying to create a test case for file_fdw for this, but I'm not getting your result. Can you send a complete test case? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
