Re: psql \dC incorrectly shows casts "with inout" as "binarycoercible" on 9.5.14 and 11beta3

Поиск
Список
Период
Сортировка
От Jean-Pierre Pelletier
Тема Re: psql \dC incorrectly shows casts "with inout" as "binarycoercible" on 9.5.14 and 11beta3
Дата
Msg-id CANGqjD=8xW2xcJ9btmoSbibJ+Zy1jQGyHTQw7dpqrMb2rkEjdg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql \dC incorrectly shows casts "with inout" as "binary coercible" on 9.5.14 and 11beta3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Btw, pg_dump is handling this right.

Jean-Pierre Pelletier

Le ven. 31 août 2018 10:33, Tom Lane <tgl@sss.pgh.pa.us> a écrit :
"jean.pierre.pelletier0" <jean.pierre.pelletier0@gmail.com> writes:
> To reproduce, compare the output of \dC on two built-in casts(json to jsonb) and (xml to text) where only the the first is really "with inout".

Hm, yeah, it just does

                      "       CASE WHEN castfunc = 0 THEN '(binary coercible)'\n"
                      "            ELSE p.proname\n"
                      "       END as \"%s\",\n"

without regard for the castmethod column (which it can't necessarily
assume is there, anyway).  It's hard to be sure after all these
years whether this was intentional or just an oversight, unless maybe
Heikki remembers ... but I tend to agree that "(with inout)" would be
more apropos than "(binary coercible)".

Not sure if this rises to the level of a back-patchable bug.
People might be surprised if we change that output in minor releases.
But we could still squeeze it into v11, I think.

                        regards, tom lane

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: PostgreSQL logical decoder output plugin - unchanged toast data
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_verify_checksums and -fno-strict-aliasing