model-writtenrun 9663 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Josh Berkus asked for a documented list of binary-compatible types #1; Thom Brown supplied a pg_cast query #2, and Noah Misch confirmed that ALTER TABLE uses that metadata and honors user-defined binary casts #5.
- Discussion of text-to-JSON conversion exposed the missing distinction between validating values and rewriting them: Noah explained that new metadata would be needed #7, Andres Freund ruled out backpatching the required changes #9, and Josh also requested rewrite-free timestamp/timestamptz conversions for UTC data #10.
- In 2015, Noah supplied planner transforms for explicit AT TIME ZONE expressions with constant zero offsets #11, explaining that ordinary casts depended on the STABLE timezone setting while planner transforms could consult only IMMUTABLE facts.
- Returning in 2019, Noah reported that the earlier implementation had landed as b8a18ad485 but caused incorrect EXPLAIN output and indxpath.c processing, so c22ecc6562 had neutralized it; he rejected a new expression-node solution as disproportionately invasive #12.
- Noah's replacement directly checked timestamp conversions in ALTER TABLE when the session timezone has a constant zero offset, supporting ordinary cast syntax and adding regression coverage; a generalized STABLE-aware support-function API was deferred for lack of another use case #12.
- Simon Riggs requested documentation #13, while Tom Lane questioned timezone stability during ALTER TABLE and whether the support-function API should be extended #14; after Noah explained the risks of exposing those semantics to extensions #15, Tom accepted the direct-check approach #16.
- At the thread's final message, Noah planned no timestamp-specific documentation because existing documentation already described binary coercion generically #17; the earlier JSON validation idea had produced no attached implementation.
- The replacement patch #12 subsequently landed unchanged apart from rebase metadata as 3c5926301a, crediting Simon Riggs and Tom Lane; it avoids qualifying table rewrites but still rebuilds indexes on affected columns.