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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Matemática A3K <matematica(dot)a3k(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "ben(at)mlabs(dot)city" <ben(at)mlabs(dot)city>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: ALTER SCHEMA: renaming does not update string-literal function bodies
Date: 2026-10-12 14:35:59
Message-ID: CAKFQuwZi36_Mer0oe6FhZmNMF57tXpoCBUY_pSf9+SW3thOE1w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Monday, October 12, 2026, Matemática A3K <matematica(dot)a3k(at)gmail(dot)com>
wrote:
>
> 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
>

It’s unclear where “all relevant places” are but it seems like a lot of
effort in response to a single report of user confusion (this one). I.e.,
maybe we aren’t as thorough as we could be but it doesn’t seem to matter in
the real world.

That said, 5.7 has a couple of example-providing sections for renaming
tables and columns. Expanding that a bit would be acceptable to me.

https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-RENAMING-TABLE

David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Matemática A3K 2026-10-12 14:46:53 Re: Documentation improvement patch
Previous Message Matemática A3K 2026-10-12 14:22:46 Re: ALTER SCHEMA: renaming does not update string-literal function bodies