From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
cc: Andres Freund <andres@anarazel.de>, Dilip Kumar <dilipbalaut@gmail.com>,
        Ashutosh Sharma <ashu.coek88@gmail.com>,
        Maciek Sakrejda <m.sakrejda@gmail.com>,
        Bruce Momjian <bruce@momjian.us>,
        Alvaro Herrera <alvherre@alvh.no-ip.org>,
        Andrew Dunstan <andrew@dunslane.net>,
        Heikki Linnakangas <hlinnaka@iki.fi>,
        PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
In-reply-to: 
 <CA+TgmobFOxt2rp0DaqHAdBAXA3KRNx2KTpzb5+1jLWfenV=K9g@mail.gmail.com>
References: 
 <CAFiTN-tb2Ot=pgqawNn3kW6nAKAiAHO9e4TRgDPgCPR3Uu40tA@mail.gmail.com>
 <CAFiTN-uZXh9R=fYyR1+z6Gszeu2SCQwKhrUqGu23O9vOh7sipg@mail.gmail.com>
 <CA+TgmoYtcdxBjLh31DLxUXHxFVMPGzrU5_T=CYCvRyFHywSBUQ@mail.gmail.com>
 <CAFiTN-uzLbV17OwcyJSLrEGEBF0YzMsRkobRD5Y_kE8M7xoAtw@mail.gmail.com>
 <CA+TgmoZHDwEjPHO6RceWZZ5L1FeJ4_VEi0t39rnWFBAbnoq53w@mail.gmail.com>
 <CAFiTN-sdxdSYObqO7-LYy=7tAB1zamT3trPq7ukfupKPMnjYdg@mail.gmail.com>
 <CAFiTN-ujhw-ttQ9-1pdcXtSn3mxhKCBQYvQsq=hQHQZwSn4xjQ@mail.gmail.com>
 <CAFiTN-tSUj56cyS6a88sgn3MWJBOA_VjEQfc7fZmWicKwijraA@mail.gmail.com>
 <CA+TgmoYVDLtS0v6XNTk=xBVStjZu_XaS5FTY74neb_h8YOcF0w@mail.gmail.com>
 <CA+TgmobUW9NQK7EJkV_0F87bqqq5BSHKiX2+wfthLcy4qA7YvQ@mail.gmail.com>
 <20220329173536.7d2ywdatsprxl4x6@alap3.anarazel.de>
 <48606.1648576426@sss.pgh.pa.us>
 <CA+Tgmob14thvsiPg_PahJZu6gsH_66PMvqJ5FYLoiOL98-CTLQ@mail.gmail.com>
 <50701.1648577840@sss.pgh.pa.us>
 <CA+TgmobFOxt2rp0DaqHAdBAXA3KRNx2KTpzb5+1jLWfenV=K9g@mail.gmail.com>
Comments: In-reply-to Robert Haas <robertmhaas@gmail.com>
	message dated "Tue, 29 Mar 2022 14:24:40 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <52603.1648579051.1@sss.pgh.pa.us>
Date: Tue, 29 Mar 2022 14:37:31 -0400
Message-ID: <52604.1648579051@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/52604.1648579051%40sss.pgh.pa.us>
Precedence: bulk

Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Mar 29, 2022 at 2:17 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> it's some random algorithm that they probably feel at liberty
>> to change.

> I guess that characterization surprises me. The man page for
> getopt_long() says this, and has for a long time at least on systems
> I've used:

Yeah, they say they follow the POSIX spec when you set POSIXLY_CORRECT.
What they don't spell out in any detail is what they do when you don't.
We know that it involves rearranging the argv[] array behind the
application's back, but not what the rules are for doing that.  In
particular, they must have some undocumented and probably not very safe
method for deciding which arguments are neither switches nor switch
arguments.

(Actually, if I recall previous discussions properly, another stumbling
block to doing anything here is that we'd also have to change all our
documentation to explain it.  Fixing the command line synopses would
be a mess already, and explaining the rules would be worse.)

			regards, tom lane