Request a Demo
Home   >   mailing lists

Re: Cast to regrole on a literal string in a PL/pgSQL function - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Cast to regrole on a literal string in a PL/pgSQL function
Date
Msg-id 218022.1759167273@sss.pgh.pa.us
Whole thread Raw
In response to Cast to regrole on a literal string in a PL/pgSQL function  (LEMAIRE Leslie (Chargée de mission) - SG/DNUM/UNI/DRC <leslie.lemaire@developpement-durable.gouv.fr>)
Responses Re: Cast to regrole on a literal string in a PL/pgSQL function
List pgsql-bugs
Tree view 
=?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>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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19067: On master at commit 66cdef4425f3, "psql -c 'select 1' dbname" causes the backend to seg fault
Next
From: Tom Lane
Date:
Subject: Re: Cast to regrole on a literal string in a PL/pgSQL function