MIME-Version: 1.0
References: <CAEpg1wBxp=25isxj6yt2cf97KtvbwxvJfrJ9qYF8UQxGSBJ93Q@mail.gmail.com>
 <1934172.1753462470@sss.pgh.pa.us> <CAEpg1wCDL+iYbG7ByjHcgfvJy7m3m-rDp-xKiYovvxeKTbG7iQ@mail.gmail.com>
 <1936547.1753463422@sss.pgh.pa.us>
In-Reply-To: <1936547.1753463422@sss.pgh.pa.us>
From: Rumpi Gravenstein <rgravens@gmail.com>
Date: Fri, 25 Jul 2025 13:18:07 -0400
Message-ID: <CAEpg1wALRocK=uDSNyJqdc=vhNGjYFmT3H_TNzihSOMS88WHfg@mail.gmail.com>
Subject: Re: PostgreSQL Bug with simple function unexpectedly treating varchar
 parameter as an array
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ce3f73063ac4202f"
Archived-At: <https://www.postgresql.org/message-id/CAEpg1wALRocK%3DuDSNyJqdc%3DvhNGjYFmT3H_TNzihSOMS88WHfg%40mail.gmail.com>
Precedence: bulk

--000000000000ce3f73063ac4202f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<snip>
Now I'm wondering about stray entries in pg_cast.  Also,
do you have any extensions loaded in that DB that aren't
in your other ones?
</snip>

Our databases are deployed with automation tools.  They should all be
created the same.  They all have the same 17 extensions.  I've asked a DBA
to confirm.

This issue only appears in the function I have listed.  A similar function,
same contents and parameter but with a different name, works the way I
would expect.


On Fri, Jul 25, 2025 at 1:10=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Rumpi Gravenstein <rgravens@gmail.com> writes:
> > No ... just one version:
>
> D'oh, actually this would have complained if there was more
> than one match, so that theory is wrong:
>
> > xxxx_pub_dev_2_db=3D# DROP FUNCTION if exists _sa_setup_role;
> > DROP FUNCTION
>
> Now I'm wondering about stray entries in pg_cast.  Also,
> do you have any extensions loaded in that DB that aren't
> in your other ones?
>
>                         regards, tom lane
>


--=20
Rumpi Gravenstein

--000000000000ce3f73063ac4202f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">&lt;snip&gt;<div>Now I&#39;m wondering about stray entries=
 in pg_cast.=C2=A0 Also,<br>do you have any extensions loaded in that DB th=
at aren&#39;t<br>in your other ones?</div><div>&lt;/snip&gt;</div><div><br>=
</div><div>Our databases are deployed with automation tools.=C2=A0 They sho=
uld all be created the same.=C2=A0 They all have the same 17 extensions.=C2=
=A0 I&#39;ve asked a DBA to confirm.</div><div><br></div><div>This issue on=
ly appears in the function I have listed.=C2=A0 A similar function, same co=
ntents and parameter but with=C2=A0a different=C2=A0name, works the=C2=A0wa=
y I would expect.=C2=A0</div><div><br></div></div><br><div class=3D"gmail_q=
uote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, J=
ul 25, 2025 at 1:10=E2=80=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.p=
a.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex">Rumpi Gravenstein &lt;<a href=3D"mailto:rgravens@gma=
il.com" target=3D"_blank">rgravens@gmail.com</a>&gt; writes:<br>
&gt; No ... just one version:<br>
<br>
D&#39;oh, actually this would have complained if there was more<br>
than one match, so that theory is wrong:<br>
<br>
&gt; xxxx_pub_dev_2_db=3D# DROP FUNCTION if exists _sa_setup_role;<br>
&gt; DROP FUNCTION<br>
<br>
Now I&#39;m wondering about stray entries in pg_cast.=C2=A0 Also,<br>
do you have any extensions loaded in that DB that aren&#39;t<br>
in your other ones?<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature">Rumpi Gravenstein<input type=3D"hidden"><input type=3D"hidden"><d=
iv></div></div>

--000000000000ce3f73063ac4202f--