model-writtenrun 6253 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Daniel Cherniy reported that postgres_fdw imported generated columns as ordinary columns and then attempted to write values into them, providing a PostgreSQL 12.4 reproduction in #1.
- Etsuro Fujita reproduced the problem and proposed remote generation; his initial patch fixed a related import_default failure that treated generation expressions as defaults #2.
- Etsuro expanded the patch to import generated expressions by default, send DEFAULT for generated columns during remote writes, support batch insertion, and stop core execution from computing generated columns for FDWs; direct-update support remained future work #3.
- Peter Eisentraut objected to ignoring declared generation expressions #4, Etsuro suggested FDWs could compute them explicitly #5, and Tom Lane requested clarification of the intended local-versus-remote semantics #6.
- Peter explained that removing local computation would break legitimate uses such as flat-file storage and exceeded a bug fix #7; Etsuro agreed to remove the core changes #8 and submitted revised patches for HEAD/PostgreSQL 14 and PostgreSQL 12–13 #9.
- Etsuro committed the final HEAD patch unchanged as aa769f80ed, with backports through PostgreSQL 12, and confirmed completion in #10; the broader core semantics changes were left out.