Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xFIGF-00000001ZLn-3bA3 for pgsql-docs@arkaria.postgresql.org; Fri, 09 Oct 2026 21:36:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xFIGE-00000001MkM-3cO5 for pgsql-docs@arkaria.postgresql.org; Fri, 09 Oct 2026 21:36:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xFIGE-00000001MkE-2gUw for pgsql-docs@lists.postgresql.org; Fri, 09 Oct 2026 21:36:14 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xFIG9-00000001IGG-3gux for pgsql-docs@lists.postgresql.org; Fri, 09 Oct 2026 21:36:14 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.18.1/8.18.1) with ESMTP id 699La6kL2985479; Fri, 9 Oct 2026 17:36:06 -0400 From: Tom Lane To: Laurenz Albe cc: ben@mlabs.city, pgsql-docs@lists.postgresql.org Subject: Re: ALTER SCHEMA: renaming does not update string-literal function bodies In-reply-to: <12030d192d4a881dff7363d035631c349a0d2514.camel@cybertec.at> References: <179157432663.2048046.109109804107041431@wrigleys.postgresql.org> <12030d192d4a881dff7363d035631c349a0d2514.camel@cybertec.at> Comments: In-reply-to Laurenz Albe message dated "Fri, 09 Oct 2026 23:22:27 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2985477.1791581766.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Fri, 09 Oct 2026 17:36:06 -0400 Message-ID: <2985478.1791581766@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Laurenz Albe 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 doc= ument > 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 tha= t it > applies to all objects? I am not sure where, but perhaps some introduct= ory > 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