Message-ID: <c6d327b17ba73a17d455e88ef002ebbd242f87ab.camel@cybertec.at>
Subject: Re: PostgreSQL Bug with simple function unexpectedly treating
 varchar parameter as an array
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Tom Lane <tgl@sss.pgh.pa.us>, Rumpi Gravenstein <rgravens@gmail.com>
Cc: PostgreSQL <pgsql-general@lists.postgresql.org>
Date: Fri, 25 Jul 2025 22:44:35 +0200
In-Reply-To: <1943137.1753467040@sss.pgh.pa.us>
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>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/c6d327b17ba73a17d455e88ef002ebbd242f87ab.camel%40cybertec.at>
Precedence: bulk

On Fri, 2025-07-25 at 14:10 -0400, Tom Lane wrote:
> After looking at the code I remembered that the parser might be taking
> this as a type coercion request.=C2=A0 With that idea, I can duplicate th=
e
> observed behavior like so:
>=20
> regression=3D# select _sa_setup_role('af_repo_app');
> INFO:=C2=A0 af_repo_app
> =C2=A0_sa_setup_role=20
> ----------------
> =C2=A0Done
> (1 row)
>=20
> regression=3D# create domain _sa_setup_role as varchar[];
> CREATE DOMAIN
> regression=3D# select _sa_setup_role('af_repo_app');
> ERROR:=C2=A0 malformed array literal: "af_repo_app"
> LINE 1: select _sa_setup_role('af_repo_app');
> =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=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 ^
> DETAIL:=C2=A0 Array value must start with "{" or dimension information.
>=20
> 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:

  CREATE DOMAIN sa_setup_role AS varchar;

  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.

Yours,
Laurenz Albe