"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thu, May 2, 2024 at 6:17 AM jian he <jian.universality@gmail.com> wrote:
>> explain (verbose, verbose off, analyze on, analyze off, analyze on)
> I have no desire to introduce breakage here. The implemented concept is
> actually quite common. The inconsistency with COPY seems like a minor
> point. It would influence my green field choice but not enough for
> changing long-standing behavior.
The argument for changing this would be consistency, but if you want
to argue for it on those grounds, you'd need to change *every* command
that acts that way. I really doubt EXPLAIN is the only one.
There's also a theological argument to be had about which
behavior is preferable. For my own taste, I like last-one-wins.
That's extremely common with command line switches, for instance.
So maybe we should be making our commands consistent in the other
direction.
regards, tom lane