Re: ALTER SCHEMA: renaming does not update string-literal function bodies

On Fri, Oct 9, 2026 at 6:36 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 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