From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?Q?LEMAIRE_Leslie_=28Charg=C3=A9e_de_mission=29_=2D_SG=2FDNUM=2F?=
 =?UTF-8?Q?UNI=2FDRC?= <leslie.lemaire@developpement-durable.gouv.fr>
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Cast to regrole on a literal string in a PL/pgSQL function
In-reply-to: <da2802eab456f4ec168b5053023bafd7@developpement-durable.gouv.fr>
References: <da2802eab456f4ec168b5053023bafd7@developpement-durable.gouv.fr>
Comments: In-reply-to
 =?UTF-8?Q?LEMAIRE_Leslie_=28Charg=C3=A9e_de_mission=29_=2D_SG=2FDNUM=2F?=
 =?UTF-8?Q?UNI=2FDRC?= <leslie.lemaire@developpement-durable.gouv.fr>
	message dated "Mon, 29 Sep 2025 14:36:15 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <218021.1759167273.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 29 Sep 2025 13:34:33 -0400
Message-ID: <218022.1759167273@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/218022.1759167273%40sss.pgh.pa.us>
Precedence: bulk

=3D?UTF-8?Q?LEMAIRE_Leslie_=3D28Charg=3DC3=3DA9e_de_mission=3D29_=3D2D_SG=3D=
2FDNUM=3D2F?=3D =3D?UTF-8?Q?UNI=3D2FDRC?=3D <leslie.lemaire@developpement-=
durable.gouv.fr> writes:
> I've noticed a rather odd behavior with a PL/pgSQL function whose =

> definition includes a cast to regrole on a literal string, such as =

> 'a_role'::regrole.

Yeah, the coverage for REG* constants in plan invalidation is pretty
thin --- in fact, I think this *only* works correctly for regclass
constants.  AFAIR you're the first to complain, so I'm not sure that
we want to expend the effort to expand that ...

			regards, tom lane