Try
Home   >   mailing lists

Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array
Date
Msg-id 1934172.1753462470@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array  (Rumpi Gravenstein <rgravens@gmail.com>)
Responses Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array
List pgsql-general
Tree view 
Rumpi Gravenstein <rgravens@gmail.com> writes:
> I've been confound by the following behavior that I see in one of our
> PostgreSQL 16 instances.  In this case I am running this script from psql.

I'd bet there is another function named _sa_setup_role() that takes
some kind of array, and the parser is resolving the ambiguity by
choosing that one.

"\df _sa_setup_role" would be illuminating.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array
Next
From: Rumpi Gravenstein
Date:
Subject: Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array