model-writtenrun 3884 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Joshua Uyehara reported that PostgreSQL 16 broke a middleware workaround using ON SELECT rules on tables, although the documentation still appeared to permit it, and asked whether the behavior could be restored #1.
- Daniel Gustafsson supplied the earlier rationale #2, while Laurenz Albe and Tom Lane explained that the old operation actually converted a table into a view and recommended creating a view directly #3 #4.
- Joshua accepted the explanation and identified the stale CREATE RULE reference paragraph, distinguishing it from the already updated chapter on views and rules #5.
- Laurenz submitted a broader patch removing explicit ON SELECT rule creation from the grammar, completion, documentation, and tests, proposing documentation backpatching to PostgreSQL 16 and code changes only for the development branch #6.
- Tom independently committed a documentation correction explaining that ON SELECT rules belong to views and that CREATE OR REPLACE RULE can still redefine them, then announced the update 95a610b097 #7; the other indexed candidate is the same change backpatched to PostgreSQL 11, with an additional explanation of the historical table-to-view conversion 3f9fe9b76f.
- The thread ended with the documentation correction landed and Laurenz's broader removal proposal opposed by Tom because older pg_dump scripts might still use CREATE OR REPLACE RULE to adjust view definitions; no revised patch or acceptance followed #8.