Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p5rkh-0002QU-Li for pgsql-docs@arkaria.postgresql.org; Thu, 15 Dec 2022 17:10:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p5rkg-0006W2-CJ for pgsql-docs@arkaria.postgresql.org; Thu, 15 Dec 2022 17:10:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p5rkg-0006Vs-5C for pgsql-docs@lists.postgresql.org; Thu, 15 Dec 2022 17:10:34 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p5rkd-0007rQ-De; Thu, 15 Dec 2022 17:10:33 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 2BFHARKO3417418; Thu, 15 Dec 2022 12:10:27 -0500 From: Tom Lane To: "Jonathan S. Katz" cc: "David G. Johnston" , splarv@ya.ru, pgsql-docs@lists.postgresql.org Subject: Re: 'value' has special behaviour in alter system In-reply-to: References: <167105927893.1897.13227723035830709578@wrigleys.postgresql.org> Comments: In-reply-to "Jonathan S. Katz" message dated "Thu, 15 Dec 2022 11:50:33 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3417416.1671124227.1@sss.pgh.pa.us> Date: Thu, 15 Dec 2022 12:10:27 -0500 Message-ID: <3417417.1671124227@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "Jonathan S. Katz" writes: > On 12/15/22 10:50 AM, David G. Johnston wrote: >> I suggest changing it to: >> SET configuration_parameter { TO | = } { value [, ...] | DEFAULT } > +1 in general. I would also suggest we add an example in the Examples > section to show what the output is when you add single-quotes. I think the core problem here is that the syntax diagram and discussion don't clearly discuss the behavior for list values. David's version of the syntax diagram looks fine, but not sure about the text. There likely needs to be some explicit acknowledgement of the fact that some GUCs act differently than others (cf GUC_LIST_INPUT and GUC_LIST_QUOTE flags). +1 for examples, for sure. regards, tom lane