Btw, pg_dump is handling this right.

Jean-Pierre Pelletier

Le ven. 31 août 2018 10:33, Tom Lane <t...@sss.pgh.pa.us> a écrit :

> "jean.pierre.pelletier0" <jean.pierre.pelleti...@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
>

Reply via email to