model-writtenrun 7495 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- A documentation report explained that the foreign-key introduction's reference to another table had led students to believe self-referential foreign keys were unsupported #1.
- Tom Lane proposed preserving the simple introduction for novices and adding an indexed explanation and tree example later in the section, supplying the thread's only attached patch #2.
- Tom Lane committed that patch with an additional paragraph relocation in doc/src/sgml/ddl.sgml e6f9539dc3.
- After the initial commit, David G. Johnston reported reading the patch, supported its tutorial approach, and suggested replacing "but non-NULL" with "while non-NULL" #3.
- Mario Wenzel noted that self-referencing columns need not generally be nullable and discussed cyclic structures and parent/child terminology, while acknowledging that a broader documentation rewrite would be more invasive #4.
- Tom Lane applied David G. Johnston's wording suggestion c38cadc090 and confirmed completion in the final reply #5; the broader terminology and nullability discussion produced no further patch in this thread.