MIME-Version: 1.0
In-Reply-To: <CAEpg1wA=sJ4Cvs3hUN9rfYBwTC74uFWYUzQGfcfZC4u-K1AH7w@mail.gmail.com>
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> <CAEpg1wBUcKjbM+vqP=JLHQUCOW9ct=aVRo1gBEtAZ5SuMY6cYQ@mail.gmail.com>
 <CAKFQuwZJJQz=Ap_S7taL1iJwS6tT0AvrVGThpxWMgQk9ZLSy2w@mail.gmail.com> <CAEpg1wA=sJ4Cvs3hUN9rfYBwTC74uFWYUzQGfcfZC4u-K1AH7w@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 6 Aug 2025 14:35:24 -0700
Message-ID: <CAKFQuwbU+xEmPdPvnvknz==yX5xLG5DuAxJASnPEcb73+WMATg@mail.gmail.com>
Subject: Re: PostgreSQL Bug with simple function unexpectedly treating varchar
 parameter as an array
To: Rumpi Gravenstein <rgravens@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Laurenz Albe <laurenz.albe@cybertec.at>, 
	PostgreSQL <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006a310f063bb91ef2"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbU%2BxEmPdPvnvknz%3D%3DyX5xLG5DuAxJASnPEcb73%2BWMATg%40mail.gmail.com>
Precedence: bulk

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

On Wednesday, August 6, 2025, Rumpi Gravenstein <rgravens@gmail.com> wrote:

> Here's a reproducible test case that causes the problem in different
> schemas.  The issue appears to be related to creating a table and a
> function that has the same name as the table with a prepended underscore.
>

Don=E2=80=99t do that.  Naming a function (action) and table (noun) the sam=
e seems
unwise anyway, underscores or no.

David J.

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

On Wednesday, August 6, 2025, Rumpi Gravenstein &lt;<a href=3D"mailto:rgrav=
ens@gmail.com">rgravens@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex"><div dir=3D"ltr">Here&#39;s a reproducible=C2=A0test case that caus=
es the problem=C2=A0in different schemas.=C2=A0 The issue appears to be rel=
ated to creating a table and a function that has the same name as the table=
 with a prepended underscore.</div></blockquote><div><br></div><div>Don=E2=
=80=99t do that.=C2=A0 Naming a function (action) and table (noun) the same=
 seems unwise anyway, underscores or no.</div><div><br></div><div>David J.<=
/div><div><br></div>

--0000000000006a310f063bb91ef2--