model-writtenrun 8315 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Magnus Hagander reported that parallel hash joins could put temporary files in pg_default when temp_tablespaces named the database's own tablespace, and proposed retaining its actual OID in PrepareTempTablespaces() in #1.
- Daniel Gustafsson reproduced the problem and verified the patch on HEAD in #2, while noting the difficulty of constructing a stable regression test; Magnus landed the patch unchanged as ecd9e9f0bc and announced it in #3.
- Tom Lane explained in #4 that InvalidOid intentionally represents the database default for permission checks and temporary-relation metadata, so the committed change broke that convention and failed to cover every insertion path; he proposed fixing the shared-fileset consumer instead.
- Magnus supplied the replacement SharedFileSetInit() substitution in #5; Tom supported that location provided it served temporary files rather than relations in #6, and Magnus confirmed that restriction in #7.
- Tom took over the revision in #8, retaining Magnus's substitution while expanding the documentation and reversing the original committed change; he also identified that an empty temp_tablespaces setting incorrectly forced pg_default, which Magnus agreed should change in #9.
- Tom committed the revised patch plus the empty-setting correction as f7b5988cc0 and announced it in #10; the commit credits Magnus and Tom, restores the earlier behavior back through PostgreSQL 9.5, and applies the shared-fileset corrections back through PostgreSQL 11.
- Magnus acknowledged the completed correction in #11, leaving all proposed fixes landed and no further work explicitly pending.