On Fri, Oct 9, 2026 at 6:36 PM Tom Lane <[email protected]> wrote:
> Laurenz Albe <[email protected]> writes: > > However, it feels odd to document that for schemas, but not for tables, > columns, > > functions and all other kinds of objects. It would be even worse to > document > > that over and over for all the ALTER commands. > > Yeah, that way madness lies. > > > How about describing that in a generic location, so that it is clear > that it > > applies to all objects? I am not sure where, but perhaps some > introductory > > note in the "Data Definition" chapter? > > I'm pretty sure there is already some text about this somewhere, > but maybe it's not in the most optimal place. > > regards, tom lane > I think the behaviour is documented in https://www.postgresql.org/docs/18/ddl-depend.html but for DROPs. Perhaps here a paragraph noting that this applies to ALTERs too (i.e. like the proposed addition) and then something like "Be aware of how [dependency tracking] works before proceeding." Although it would have to be put in all relevant places to be consistent... This may be a lot of work but I volunteer to do it if deemed so
