Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1ufLoZ-0064GO-Cp
	for pgsql-general@arkaria.postgresql.org; Fri, 25 Jul 2025 17:02:36 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1ufLoX-002yPK-Li
	for pgsql-general@arkaria.postgresql.org; Fri, 25 Jul 2025 17:02:33 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1ufLoX-002yOg-BO
	for pgsql-general@lists.postgresql.org; Fri, 25 Jul 2025 17:02:33 +0000
Received: from fhigh-b2-smtp.messagingengine.com ([202.12.124.153])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1ufLoU-000oDo-0q
	for pgsql-general@lists.postgresql.org;
	Fri, 25 Jul 2025 17:02:33 +0000
Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41])
	by mailfhigh.stl.internal (Postfix) with ESMTP id 1F4077A0104;
	Fri, 25 Jul 2025 13:02:29 -0400 (EDT)
Received: from phl-mailfrontend-02 ([10.202.2.163])
  by phl-compute-01.internal (MEProxy); Fri, 25 Jul 2025 13:02:29 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:cc:content-transfer-encoding:content-type:content-type:date
	:date:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm1; t=1753462948;
	 x=1753549348; bh=071/E70Zn9YYXTuyp+XFem46vroFehSb37dqJHwqJI4=; b=
	cfbChjJAYbCi/jS0R0M4Mze22J7Ppp68fBHn8UVHvJNJUbbpuTjs//WgYhmf45Qw
	naOTcjdQpVPdR+cCMys4HTE/4Tk3ieYCWuVOv/aG1eHEwc+kCS3ZKa2CjhAOzQmU
	jsQUb5Yo8RErRc2MewG6tn6ohkUfrwvLYdclzix0ljZSOiQmpJM3w5ux983r8t0m
	wVuuNfcPMJpzfA2VTIaiZeaEWWGRYJUhgLCCqjKSRoUsMZUNNEgQMwPNw6XZTmCn
	sOfhfHrMv0s5PAoma+hD+Qf9mUP/0pnvRMCbYynIdwED0FpLZqml+DCnl9JtaQ33
	5dHsKXFrXH3ZZnoQan7YRw==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1753462948; x=
	1753549348; bh=071/E70Zn9YYXTuyp+XFem46vroFehSb37dqJHwqJI4=; b=I
	2DcrfbsrgFv1hXh/8XBHDmhUvruByb9XdVkoLEWg68dlVWhlC/ur/cLUOWjHUBg9
	//BIp4QUZtTUr22N/zWkdXznquqyFaWKZalE+lss4cmiJ82i3hPnpK/V8wRrCFI+
	9R5gY5EiFbmLLVRpXZFXusj2WO5LvIfnfiOjn0sJy+RoX80oDVfe40l+ZIpi9zN3
	7RtP6beS0zB7bT/VvQ/YqdcdanePbLH2TMevLVogLX8y2EbftXJJ62ytB0AMInCe
	Lprc2fVgU9GvPkdaw5PoMkf2pItXbJSJBi8YCMJC3P/XYCr21iFWsL1S3JL2NVZ4
	7m94WhLdChsm/PBZ+NrBw==
X-ME-Sender: <xms:pLiDaOQa2yQnhF3aosg7WnPNZCQrts7bc_CPVWnx4er8md2lr28rcA>
    <xme:pLiDaOpUdnuB1gqGbHf9hGZQEBKKPMRUR6yvgpo3Uq_ovTAw3CE4dQBzBcOmBRDvt
    dAwIPk8OcDYZMk>
X-ME-Received: <xmr:pLiDaDokk3gBnjp86Qo1AakFHnT88WEIkopl3HoVdd7n7l4OVJRiFqoPG68cxxT0PNRmQAu1539Cm6FeSG3dMtfYAiP3_Q>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdekgedtkecutefuodetggdotefrod
    ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr
    ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug
    hrpefkffggfgfuvfevfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhirghn
    ucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqe
    enucggtffrrghtthgvrhhnpefhveeihfevlefffedthedukeevfefhfedtgeeifeevteff
    gfefhedtffetudettdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrih
    hlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggp
    rhgtphhtthhopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehrghhrrghvvg
    hnshesghhmrghilhdrtghomhdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdr
    uhhspdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtgh
    hrvghsqhhlrdhorhhg
X-ME-Proxy: <xmx:pLiDaIOWlKjayCBNqN82VxMPZrWt0VtsZUDhkvso5rpqNmmvJjHBIQ>
    <xmx:pLiDaMzVYXoICmodaiKbfXJwMynSCJ9tpOhSmX51YBX1lKzu4xaJSg>
    <xmx:pLiDaJuFDq_C4MddSFOv6cyQYTZ6ha8CIjpf1rM3SJ84ieQSPThi7A>
    <xmx:pLiDaN5ysnhjavtfm4nwDvOef65Nwd8wO5p28zH5BzXA413WRZqoGg>
    <xmx:pLiDaKpLs0rLwpfpRpdnxmKGBxzYzTp3lpSdGHUwmfWLK2BCAhGZnYqG>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri,
 25 Jul 2025 13:02:28 -0400 (EDT)
Message-ID: <a44ef5a5-4873-4a3b-91e5-6724a1b91701@aklaver.com>
Date: Fri, 25 Jul 2025 10:02:27 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: PostgreSQL Bug with simple function unexpectedly treating varchar
 parameter as an array
To: Rumpi Gravenstein <rgravens@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL <pgsql-general@lists.postgresql.org>
References: <CAEpg1wBxp=25isxj6yt2cf97KtvbwxvJfrJ9qYF8UQxGSBJ93Q@mail.gmail.com>
 <1934172.1753462470@sss.pgh.pa.us>
 <CAEpg1wCDL+iYbG7ByjHcgfvJy7m3m-rDp-xKiYovvxeKTbG7iQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEpg1wCDL+iYbG7ByjHcgfvJy7m3m-rDp-xKiYovvxeKTbG7iQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/a44ef5a5-4873-4a3b-91e5-6724a1b91701%40aklaver.com>
Precedence: bulk

On 7/25/25 09:59, Rumpi Gravenstein wrote:
> No ... just one version:
> 

> 
> xxxx_pub_dev_2_db=# \df _sa_setup_role

Do:

\df *._sa_setup_role

> 
> -- 
> Rumpi Gravenstein


-- 
Adrian Klaver
adrian.klaver@aklaver.com