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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: ben(at)mlabs(dot)city, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: ALTER SCHEMA: renaming does not update string-literal function bodies
Date: 2026-10-09 21:36:06
Message-ID: 2985478.1791581766@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2026-10-09 22:25:06 Re: Table 9.46. UUID Extraction Functions
Previous Message Laurenz Albe 2026-10-09 21:22:27 Re: ALTER SCHEMA: renaming does not update string-literal function bodies