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> <CAEpg1wALRocK=uDSNyJqdc=vhNGjYFmT3H_TNzihSOMS88WHfg@mail.gmail.com>
 <1940680.1753465819@sss.pgh.pa.us> <1943137.1753467040@sss.pgh.pa.us>
 <c6d327b17ba73a17d455e88ef002ebbd242f87ab.camel@cybertec.at> <2223785.1753476729@sss.pgh.pa.us>
In-Reply-To: <2223785.1753476729@sss.pgh.pa.us>
From: Rumpi Gravenstein <rgravens@gmail.com>
Date: Wed, 6 Aug 2025 16:17:36 -0400
Message-ID: <CAEpg1wBUcKjbM+vqP=JLHQUCOW9ct=aVRo1gBEtAZ5SuMY6cYQ@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: Laurenz Albe <laurenz.albe@cybertec.at>, 
	PostgreSQL <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d01ca2063bb80834"
Archived-At: <https://www.postgresql.org/message-id/CAEpg1wBUcKjbM%2BvqP%3DJLHQUCOW9ct%3DaVRo1gBEtAZ5SuMY6cYQ%40mail.gmail.com>
Precedence: bulk

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

Just coming back to this.  Don't know how to interpret this:

xxx_pub_dev_2_db=3D# select proname, pronamespace, oid from pg_proc where
proname like '%sa_setup%';
    proname     | pronamespace |   oid
----------------+--------------+---------
_sa_setup_role |      7038406 | 7869125
(1 row)

xxx_pub_dev_2_db=3D# drop FUNCTION if exists _sa_setup_role;
DROP FUNCTION
xxx_pub_dev_2_db=3D# select proname, pronamespace, oid from pg_proc where
proname like '%sa_setup%';
proname | pronamespace | oid
---------+--------------+-----
(0 rows)

xxx_pub_dev_2_db=3D# select _sa_setup_role('af_repo_app');
ERROR:  malformed array literal: "af_repo_app"
LINE 1: select _sa_setup_role('af_repo_app');
                              ^
DETAIL:  Array value must start with "{" or dimension information.
xxx_pub_dev_2_db=3D#

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

> Laurenz Albe <laurenz.albe@cybertec.at> writes:
> > On Fri, 2025-07-25 at 14:10 -0400, Tom Lane wrote:
> >> So ... any chance you have a data type named _sa_setup_role?
>
> > ... it could also be a type "sa_setup_role", and "_sa_setup_role"
> > is interpreted as the corresponding array type:
>
> Oh, of course --- that's a good deal more likely than my version.
>
>                         regards, tom lane
>


--=20
Rumpi Gravenstein

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

<div dir=3D"ltr">Just coming back to this.=C2=A0 Don&#39;t know how to inte=
rpret this:<br><br>xxx_pub_dev_2_db=3D# select proname, pronamespace, oid f=
rom pg_proc where proname like &#39;%sa_setup%&#39;;<br>=C2=A0 =C2=A0 prona=
me =C2=A0 =C2=A0 | pronamespace | =C2=A0 oid<br>----------------+----------=
----+---------<br>_sa_setup_role | =C2=A0 =C2=A0 =C2=A07038406 | 7869125<br=
>(1 row)<br>=C2=A0<br>xxx_pub_dev_2_db=3D# drop FUNCTION if exists _sa_setu=
p_role;<br>DROP FUNCTION<br>xxx_pub_dev_2_db=3D# select proname, pronamespa=
ce, oid from pg_proc where proname like &#39;%sa_setup%&#39;;<br>proname | =
pronamespace | oid<br>---------+--------------+-----<br>(0 rows)<br>=C2=A0<=
br>xxx_pub_dev_2_db=3D# select _sa_setup_role(&#39;af_repo_app&#39;);<br>ER=
ROR: =C2=A0malformed array literal: &quot;af_repo_app&quot;<br>LINE 1: sele=
ct _sa_setup_role(&#39;af_repo_app&#39;);<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 =C2=A0 =C2=A0 =C2=
=A0 ^<br>DETAIL: =C2=A0Array value must start with &quot;{&quot; or dimensi=
on information.<br>xxx_pub_dev_2_db=3D#</div><br><div class=3D"gmail_quote =
gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 25=
, 2025 at 4:52=E2=80=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.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">Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.=
at" target=3D"_blank">laurenz.albe@cybertec.at</a>&gt; writes:<br>
&gt; On Fri, 2025-07-25 at 14:10 -0400, Tom Lane wrote:<br>
&gt;&gt; So ... any chance you have a data type named _sa_setup_role?<br>
<br>
&gt; ... it could also be a type &quot;sa_setup_role&quot;, and &quot;_sa_s=
etup_role&quot;<br>
&gt; is interpreted as the corresponding array type:<br>
<br>
Oh, of course --- that&#39;s a good deal more likely than my version.<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>

--000000000000d01ca2063bb80834--