Re: EXPLAN redundant options - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: EXPLAN redundant options
Date
Msg-id CAKFQuwb6ndjEzT0mcfCFLxU4DP5Y1pDqs4QtNmNA=nA+C1uRbQ@mail.gmail.com
Whole thread Raw
In response to EXPLAN redundant options  (jian he <jian.universality@gmail.com>)
Responses Re: EXPLAN redundant options  ("Euler Taveira" <euler@eulerto.com>)
Re: EXPLAN redundant options  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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 would just update this paragraph to note the last one wins behavior.

"When the option list is surrounded by parentheses, the options can be written in any order.  However, if options are repeated the last one listed is used."

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.

David J.

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: EXPLAN redundant options
Next
From: Peter Eisentraut
Date:
Subject: Re: Support LIKE with nondeterministic collations