Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rXZ7X-00BIAr-HS for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Feb 2024 04:01:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rXZ7W-007pEI-HT for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Feb 2024 04:01:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rXZ7W-007pEA-4L for pgsql-bugs@lists.postgresql.org; Wed, 07 Feb 2024 04:01:10 +0000 Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rXZ7S-005sAY-Iq for pgsql-bugs@lists.postgresql.org; Wed, 07 Feb 2024 04:01:09 +0000 Received: by mail-wm1-x32a.google.com with SMTP id 5b1f17b1804b1-40fff96d5d7so1258085e9.2 for ; Tue, 06 Feb 2024 20:01:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1707278465; x=1707883265; darn=lists.postgresql.org; h=mime-version:user-agent:autocrypt:references:in-reply-to:date:to :from:subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=5U9LrflT/aknvj2X1R2OBCKRxgWNS6zupjW2bHU6A6k=; b=2I4ZcHi6B7F4PiG277TuupjFEzKDMON4WnzynjQrO9FiG7Ns+YCAgUBYX6PDsM5dQ7 BlJYDhQlf86CLekxDHrUANMzgyT9TwELVBJtMxAw0nO+sNeg/Vg4pQQLnaZZ2zYDk9i/ qqICyCNhH+KvwQH8mKJ7hQwW0Nm0+alaXuxbsDQr64WMGrp+43I5N21DklEuMLcB34mZ dk0vbCEX1cqD2RvdlCESSl44VjnexHFgKVEt/ORC7lyUOh/+HaPKbnsX2ApAMwML4gQJ uN6n/wVGo2xAonh35Srs2ad4v9YyaatTQx4w4P6M7L2hsIYS1cKGm+4+hzHCyhvHxaAl Kgeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1707278465; x=1707883265; h=mime-version:user-agent:autocrypt:references:in-reply-to:date:to :from:subject:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=5U9LrflT/aknvj2X1R2OBCKRxgWNS6zupjW2bHU6A6k=; b=wSxkADXj+8ndvfsDtRE2hdiDtOAIdnyawBvX2T9Biv5oxd0NiI1HFz0RA1MizZ4n8H 7JXNR/qif2NUbBnwM5gYtWo6yU/Z3hdwbuge9lJpagnmUdiWXEMf3Cuk3sBHNLYrA3WR 9JLg0uilaR8jqURKROOuBbnMXC/hXmGcEjQeTewoV9XPiA6chtTxjKPWQyxn+DtXLFL+ ogtAeLjE/V692aJtWCPHAjDSv3m/dkAxM6z0N5jWJhNllDZ2xJHpSFPkbjbSyJw0iX6j jlXpdgsqI0sB2azXQ82xCh5VbFjfLvjIfdo3RW4xn7OtxRV0KRDAxR/bFjZRWGumJmXl b9Tg== X-Forwarded-Encrypted: i=1; AJvYcCUTPLACGI2RXk5Y+OIrdbcyrrpjwCA4Xe7SF7mkeFDxl/gmACYjhanyNeAKasUiV/HJrEc+z2rZiZbNzWIE7myFnxX966ndLA9kCtpl5MQJ X-Gm-Message-State: AOJu0YxtLsL7xxn7V8K8lZufDO2Qdz4ifmjRhThnUCWeE0HT8nx58aGe KbS6v9t1eEqp4Q16sNWAqap5u9pqsozQnTsrWfCBiU5KPuu779R3isoiDtRur0s= X-Google-Smtp-Source: AGHT+IGjM7YDwNTz7vwd9oCiZWzv1jn9Ilj3+QHZUkioXs/oleUnMgU9FDhOpwiMQjDQGVLxvnH4Eg== X-Received: by 2002:a05:600c:3b08:b0:410:ae8:4c43 with SMTP id m8-20020a05600c3b0800b004100ae84c43mr355458wms.20.1707278464989; Tue, 06 Feb 2024 20:01:04 -0800 (PST) X-Forwarded-Encrypted: i=1; AJvYcCVl1tgeOpbX5Y8doGRcAOwEC/M1+4nUsHr0kAB5xJhN/rXoPKOCcc/MmzW+XyR0S3WviJykonwfewEgvTF3R5twRH5pactDLDaTrm3G70tw Received: from localhost.localdomain ([46.151.204.202]) by smtp.gmail.com with ESMTPSA id l14-20020a05600c4f0e00b0040ec8330c8asm3813564wmq.39.2024.02.06.20.01.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 06 Feb 2024 20:01:04 -0800 (PST) Message-ID: <94d001ada27f1b39f00370a784395667aa6d44aa.camel@cybertec.at> Subject: Re: BUG #18336: Inconsistency in PostgreSQL 16 Documentation for SHOW Command From: Laurenz Albe To: masano@sraoss.co.jp, pgsql-bugs@lists.postgresql.org Date: Wed, 07 Feb 2024 05:01:03 +0100 In-Reply-To: <18336-d3652b898b550423@postgresql.org> References: <18336-d3652b898b550423@postgresql.org> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: multipart/mixed; boundary="=-nS5hMX4M2Nd9ms4M+e40" User-Agent: Evolution 3.50.3 (3.50.3-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-nS5hMX4M2Nd9ms4M+e40 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, 2024-02-07 at 02:25 +0000, PG Bug reporting form wrote: > In the PostgreSQL 16 release notes, there is an entry stating that the > read-only server variables lc_collate and lc_ctype have been removed. > However, the documentation for the SHOW command on the PostgreSQL officia= l > website (https://www.postgresql.org/docs/current/sql-show.html) still lis= ts > lc_collate and lc_ctype as valid variables. Right; here is a patch for that. Yours, Laurenz Albe --=-nS5hMX4M2Nd9ms4M+e40 Content-Disposition: attachment; filename*0=v1-0001-Remove-documentation-for-SHOW-LC_COLLATE-LC_CTYPE.pat; filename*1=ch Content-Type: text/x-patch; name="v1-0001-Remove-documentation-for-SHOW-LC_COLLATE-LC_CTYPE.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSA0MjA1ZTk4YTk4ODVlMTJmYjE1Y2YwMmVhNjE5ZGVlYjMxYmM4MDJhIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogV2VkLCA3IEZlYiAyMDI0IDA0OjU1OjUxICswMTAwClN1YmplY3Q6IFtQQVRDSCB2 MV0gUmVtb3ZlIGRvY3VtZW50YXRpb24gZm9yIFNIT1cgTENfQ09MTEFURS9MQ19DVFlQRQoKVGhl c2UgaGF2ZSBiZWVuIHJlbW92ZWQgaW4gYjBmNmM0MzcxNiwgYnV0IHRoZSBkb2N1bWVudGF0aW9u IHdhcwpub3QgdXBkYXRlZC4KClJlcG9ydGVkLWJ5OiBZdXRhIE1hc2FubwpCYWNrcGF0Y2gtdG86 IDE2CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTgzMzYtZDM2NTJiODk4YjU1MDQy M0Bwb3N0Z3Jlc3FsLm9yZwotLS0KIGRvYy9zcmMvc2dtbC9yZWYvc2hvdy5zZ21sIHwgMjQgLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgMjQgZGVsZXRpb25zKC0pCgpk aWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL3JlZi9zaG93LnNnbWwgYi9kb2Mvc3JjL3NnbWwvcmVm L3Nob3cuc2dtbAppbmRleCBiMzc0N2IxMTlmLi41ZmJiNWJiZTAxIDEwMDY0NAotLS0gYS9kb2Mv c3JjL3NnbWwvcmVmL3Nob3cuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvcmVmL3Nob3cuc2dtbApA QCAtNzcsMzAgKzc3LDYgQEAgU0hPVyBBTEwKICAgICAgICAgPC9saXN0aXRlbT4KICAgICAgICA8 L3Zhcmxpc3RlbnRyeT4KIAotICAgICAgIDx2YXJsaXN0ZW50cnk+Ci0gICAgICAgIDx0ZXJtPjxs aXRlcmFsPkxDX0NPTExBVEU8L2xpdGVyYWw+PC90ZXJtPgotICAgICAgICA8bGlzdGl0ZW0+Ci0g ICAgICAgICA8cGFyYT4KLSAgICAgICAgICBTaG93cyB0aGUgZGF0YWJhc2UncyBsb2NhbGUgc2V0 dGluZyBmb3IgY29sbGF0aW9uICh0ZXh0Ci0gICAgICAgICAgb3JkZXJpbmcpLiAgQXQgcHJlc2Vu dCwgdGhpcyBwYXJhbWV0ZXIgY2FuIGJlIHNob3duIGJ1dCBub3QKLSAgICAgICAgICBzZXQsIGJl Y2F1c2UgdGhlIHNldHRpbmcgaXMgZGV0ZXJtaW5lZCBhdCBkYXRhYmFzZSBjcmVhdGlvbgotICAg ICAgICAgIHRpbWUuCi0gICAgICAgICA8L3BhcmE+Ci0gICAgICAgIDwvbGlzdGl0ZW0+Ci0gICAg ICAgPC92YXJsaXN0ZW50cnk+Ci0KLSAgICAgICA8dmFybGlzdGVudHJ5PgotICAgICAgICA8dGVy bT48bGl0ZXJhbD5MQ19DVFlQRTwvbGl0ZXJhbD48L3Rlcm0+Ci0gICAgICAgIDxsaXN0aXRlbT4K LSAgICAgICAgIDxwYXJhPgotICAgICAgICAgIFNob3dzIHRoZSBkYXRhYmFzZSdzIGxvY2FsZSBz ZXR0aW5nIGZvciBjaGFyYWN0ZXIKLSAgICAgICAgICBjbGFzc2lmaWNhdGlvbi4gIEF0IHByZXNl bnQsIHRoaXMgcGFyYW1ldGVyIGNhbiBiZSBzaG93biBidXQKLSAgICAgICAgICBub3Qgc2V0LCBi ZWNhdXNlIHRoZSBzZXR0aW5nIGlzIGRldGVybWluZWQgYXQgZGF0YWJhc2UgY3JlYXRpb24KLSAg ICAgICAgICB0aW1lLgotICAgICAgICAgPC9wYXJhPgotICAgICAgICA8L2xpc3RpdGVtPgotICAg ICAgIDwvdmFybGlzdGVudHJ5PgotCiAgICAgICAgPHZhcmxpc3RlbnRyeT4KICAgICAgICAgPHRl cm0+PGxpdGVyYWw+SVNfU1VQRVJVU0VSPC9saXRlcmFsPjwvdGVybT4KICAgICAgICAgPGxpc3Rp dGVtPgotLSAKMi40My4wCgo= --=-nS5hMX4M2Nd9ms4M+e40--