Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array
Дата
Msg-id 1943137.1753467040@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array
Список pgsql-general
I wrote:
> Well, there's got to be *something* different about that database.

After looking at the code I remembered that the parser might be taking
this as a type coercion request.  With that idea, I can duplicate the
observed behavior like so:

regression=# select _sa_setup_role('af_repo_app');
INFO:  af_repo_app
 _sa_setup_role 
----------------
 Done
(1 row)

regression=# create domain _sa_setup_role as varchar[];
CREATE DOMAIN
regression=# 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.

So ... any chance you have a data type named _sa_setup_role?

            regards, tom lane



В списке pgsql-general по дате отправления: