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 1m4hy7-000856-Qz for pgsql-bugs@arkaria.postgresql.org; Sat, 17 Jul 2021 10:54:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m4hy6-0000aV-PQ for pgsql-bugs@arkaria.postgresql.org; Sat, 17 Jul 2021 10:54:50 +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 1m4c7z-0005Du-1s for pgsql-bugs@lists.postgresql.org; Sat, 17 Jul 2021 04:40:39 +0000 Received: from [124.133.18.218] (helo=EX02.highgo.com) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1m4c7q-0007UR-C2 for pgsql-bugs@lists.postgresql.org; Sat, 17 Jul 2021 04:40:37 +0000 Received: from leiyanliang (111.37.19.183) by EX02.highgo.com (192.168.110.195) with Microsoft SMTP Server (TLS) id 15.0.847.32; Sat, 17 Jul 2021 12:40:24 +0800 Date: Sat, 17 Jul 2021 12:40:25 +0800 From: "leiyanliang@highgo.com" To: "leiyanliang@highgo.com" , "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #17077: about three parameters in postgresql 13.3 References: <17077-ade8e166a01e1374@postgresql.org> X-Priority: 3 X-Has-Attach: no X-Mailer: Foxmail 7, 2, 7, 21[cn] MIME-Version: 1.0 Message-ID: <202107171236202362593@highgo.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart385407426340_=----" X-Originating-IP: [111.37.19.183] X-ClientProxiedBy: EX02.highgo.com (192.168.110.195) To EX02.highgo.com (192.168.110.195) X-Host-Lookup-Failed: Reverse DNS lookup failed for 124.133.18.218 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_001_NextPart385407426340_=---- Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 SSB3YW50IHRvIGtub3c6IHRoaXMgYnVnIHJlcG9ydCBpcyBhIHByb2JsZW0gb3Igbm90ID8NCg0K DQoNCg0KDQogDQpGcm9tOiBQRyBCdWcgcmVwb3J0aW5nIGZvcm0NCkRhdGU6IDIwMjEtMDYtMzAg MTQ6MDkNClRvOiBwZ3NxbC1idWdzQGxpc3RzLnBvc3RncmVzcWwub3JnDQpDQzogbGVpeWFubGlh bmdAaGlnaGdvLmNvbQ0KU3ViamVjdDogQlVHICMxNzA3NzogYWJvdXQgdGhyZWUgcGFyYW1ldGVy cyBpbiBwb3N0Z3Jlc3FsIDEzLjMNClRoZSBmb2xsb3dpbmcgYnVnIGhhcyBiZWVuIGxvZ2dlZCBv biB0aGUgd2Vic2l0ZToNCiANCkJ1ZyByZWZlcmVuY2U6ICAgICAgMTcwNzcNCkxvZ2dlZCBieTog ICAgICAgICAgeWFubGlhbmcgbGVpDQpFbWFpbCBhZGRyZXNzOiAgICAgIGxlaXlhbmxpYW5nQGhp Z2hnby5jb20NClBvc3RncmVTUUwgdmVyc2lvbjogMTMuMw0KT3BlcmF0aW5nIHN5c3RlbTogICBD ZW50T1M3LjYNCkRlc2NyaXB0aW9uOiAgICAgICAgDQogDQpUaHJlZSBwYXJhbWV0ZXJzIGFyZQ0K J3RyYW5zYWN0aW9uX2RlZmVycmFibGUnLCd0cmFuc2FjdGlvbl9pc29sYXRpb24nLCd0cmFuc2Fj dGlvbl9yZWFkX29ubHkn44CCDQogDQppbiB0aGUgZm9sbG93aW5nIHNxbCBzdGF0ZW1lbnQsdGhl cmUgYXJlICB0aHJlZQ0KcGFyYW1ldGVyc++8iCd0cmFuc2FjdGlvbl9kZWZlcnJhYmxlJywndHJh bnNhY3Rpb25faXNvbGF0aW9uJywndHJhbnNhY3Rpb25fcmVhZF9vbmx5J++8iQ0KIA0KW3BnMTMz QFZNLTAtOC1jZW50b3Mgfl0kIHBzcWwgLWQgcG9zdGdyZXMNCnBzcWwgKDEzLjMpDQpUeXBlICJo ZWxwIiBmb3IgaGVscC4NCiANCnBvc3RncmVzPSMgc2VsZWN0ICogZnJvbSBwZ19zZXR0aW5ncyB3 aGVyZSBuYW1lIGluDQooJ3RyYW5zYWN0aW9uX2RlZmVycmFibGUnLCd0cmFuc2FjdGlvbl9pc29s YXRpb24nLCd0cmFuc2FjdGlvbl9yZWFkX29ubHknKTsNCiAgICAgICAgICBuYW1lICAgICAgICAg IHwgICAgc2V0dGluZyAgICAgfCB1bml0IHwgICAgICAgICAgICAgICAgICAgDQpjYXRlZ29yeSAg ICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgDQogICAgICAgIHNob3J0X2Rlc2MgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwNCmV4dHJhX2Rlc2MgfCBjDQpvbnRleHQgfCB2 YXJ0eXBlIHwgIHNvdXJjZSAgfCBtaW5fdmFsIHwgbWF4X3ZhbCB8ICAgICAgICAgICAgICAgICAg ICAgICAgICAgDQogICBlbnVtdmFscyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAg IGJvb3RfdmFsICAgIHwgICByZXNldF92YWwgICANCnwgc291cmNlZmlsZSB8IHNvdXJjZWxpbmUg fCBwZW5kaW5nX3Jlc3RhcnQgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t LS0tLSstLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLQ0KLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0t LSstLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0N CnRyYW5zYWN0aW9uX2RlZmVycmFibGUgfCBvZmYgICAgICAgICAgICB8ICAgICAgfCBDbGllbnQg Q29ubmVjdGlvbiBEZWZhdWx0cw0KLyBTdGF0ZW1lbnQgQmVoYXZpb3IgfCBXaGV0aGVyIHRvIGRl ZmVyIGEgcmVhZC1vbmx5IHNlcmlhbGl6YWJsZSB0cmFuc2FjdGlvbg0KdW50aWwgaXQgY2FuIGJl IGV4ZWN1dGVkIHdpdGggbm8gcG9zc2libGUgc2VyaWFsaXphdGlvbiBmYWlsdXJlcy4gfCAgICAg ICAgIA0KICB8IHUNCnNlciAgICB8IGJvb2wgICAgfCBvdmVycmlkZSB8ICAgICAgICAgfCAgICAg ICAgIHwgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIHwgb2ZmICAgICAgICAgICAgfCBvZmYgICAgICAgICAgIA0KfCAg ICAgICAgICAgIHwgICAgICAgICAgICB8IGYNCnRyYW5zYWN0aW9uX2lzb2xhdGlvbiAgfCByZWFk IGNvbW1pdHRlZCB8ICAgICAgfCBDbGllbnQgQ29ubmVjdGlvbiBEZWZhdWx0cw0KLyBTdGF0ZW1l bnQgQmVoYXZpb3IgfCBTZXRzIHRoZSBjdXJyZW50IHRyYW5zYWN0aW9uJ3MgaXNvbGF0aW9uIGxl dmVsLiAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgIA0KICB8IHUNCnNlciAgICB8IGVudW0gICAg fCBvdmVycmlkZSB8ICAgICAgICAgfCAgICAgICAgIHwge3NlcmlhbGl6YWJsZSwicmVwZWF0YWJs ZQ0KcmVhZCIsInJlYWQgY29tbWl0dGVkIiwicmVhZCB1bmNvbW1pdHRlZCJ9IHwgcmVhZCBjb21t aXR0ZWQgfCByZWFkIGNvbW1pdHRlZA0KfCAgICAgICAgICAgIHwgICAgICAgICAgICB8IGYNCnRy YW5zYWN0aW9uX3JlYWRfb25seSAgfCBvZmYgICAgICAgICAgICB8ICAgICAgfCBDbGllbnQgQ29u bmVjdGlvbiBEZWZhdWx0cw0KLyBTdGF0ZW1lbnQgQmVoYXZpb3IgfCBTZXRzIHRoZSBjdXJyZW50 IHRyYW5zYWN0aW9uJ3MgcmVhZC1vbmx5IHN0YXR1cy4gICAgIA0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAg IA0KICB8IHUNCnNlciAgICB8IGJvb2wgICAgfCBvdmVycmlkZSB8ICAgICAgICAgfCAgICAgICAg IHwgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIHwgb2ZmICAgICAgICAgICAgfCBvZmYgICAgICAgICAgIA0KfCAgICAg ICAgICAgIHwgICAgICAgICAgICB8IGYNCigzIHJvd3MpDQogDQpwb3N0Z3Jlcz0jIA0KIA0KaW4g dGhlDQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvcnVudGltZS1jb25m aWctY2xpZW50Lmh0bWwjUlVOVElNRS1DT05GSUctQ0xJRU5ULVNUQVRFTUVOVA0KIA0KdGhlcmUg aXMgbm8gZGVzY3JpcHRpb24gYWJvdXQgdGhlc2UgdGhyZWUgcGFyYW1ldGVyc+OAgg0KIA0K ------=_001_NextPart385407426340_=---- Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable =0A
I want to know: = this bug report is a problem or not ?

<= /span>


=0A
<= span>
 
= Date: 2021-06-30 14:09
Subject: BUG #17077: about th= ree parameters in postgresql 13.3
The following= bug has been logged on the website:
=0A
 
=0A
Bug = reference:      17077
=0A
Logged by:&nbs= p;         yanliang lei
=0AEmail address:      leiyanliang@highgo.com=0A
PostgreSQL version: 13.3
=0A
Operating system: &nb= sp; CentOS7.6
=0A
Description:      = ; 
=0A
 
=0A
Three parameters are
=0A'transaction_deferrable','transaction_isolation','transaction_read_only'= =E3=80=82
=0A
 
=0A
in the following sql statement,= there are  three
=0A
parameters=EF=BC=88'transaction_deferra= ble','transaction_isolation','transaction_read_only'=EF=BC=89
=0A 
=0A
[pg133@VM-0-8-centos ~]$ psql -d postgres
=0Apsql (13.3)=0A
Type "help" for help.
=0A
 
= =0A
postgres=3D# select * from pg_settings where name in
=0A
= ('transaction_deferrable','transaction_isolation','transaction_read_only')= ;
=0A
          name=           |   = setting     | unit |     &nb= sp;            = ;
=0A
category        &n= bsp;            |&n= bsp;           &nbs= p;            =             &n= bsp;       
=0A
  &= nbsp;     short_desc     &nbs= p;            =             &n= bsp;           &nbs= p;            = |
=0A
extra_desc | c
=0A
ontext | vartype |  sourc= e  | min_val | max_val |       &nb= sp;            = ;      
=0A
   enumvals&= nbsp;           &nb= sp;            = ;      |    boot_val  &n= bsp; |   reset_val  
=0A
| sourcefile | sour= celine | pending_restart
=0A
------------------------+----------= ------+------+-------------------------------------------------+----------= --------------------------------------------------------------------------= -------------------------------------+------------+--
=0A
-------= +---------+----------+---------+---------+--------------------------------= --------------------------------------+----------------+----------------+-= -----------+------------+-----------------
=0A
transaction_defer= rable | off          &nb= sp; |      | Client Connection Defaults
=0A<= div>/ Statement Behavior | Whether to defer a read-only serializable trans= action=0A
until it can be executed with no possible serializatio= n failures. |        
=0A  | u=0A
ser    | bool    |= override |         |  &= nbsp;      |      &= nbsp;           &nb= sp;       
=0A
  &n= bsp;           &nbs= p;            =             &n= bsp;  | off         &nbs= p;  | off          =
=0A
|         &nbs= p;  |          &nbs= p; | f
=0A
transaction_isolation  | read committed | &= nbsp;    | Client Connection Defaults
=0A
/ Statem= ent Behavior | Sets the current transaction's isolation level.  =    
=0A
       = ;            &= nbsp;           &nb= sp;            = ;            &= nbsp;         |   &= nbsp;    
=0A
  | u
=0A
ser&nb= sp;   | enum    | override |   &nb= sp;     |       &nb= sp; | {serializable,"repeatable
=0A
read","read committed","read = uncommitted"} | read committed | read committed
=0A
|  =           |   =          | f
=0A
transac= tion_read_only  | off        =     |      | Client Connection Def= aults
=0A
/ Statement Behavior | Sets the current transaction's r= ead-only status.    
=0A
   &= nbsp;           &nb= sp;            = ;            &= nbsp;           &nb= sp;            = ; |        
=0A
  |= u
=0A
ser    | bool    | override = |         |    = ;     |        = ;            &= nbsp;     
=0A
    =             &n= bsp;           &nbs= p;            = | off            |= off          
=0A=
|            |=             | f=0A
(3 rows)
=0A
 
=0A
postgres=3D#
=0A=
 
=0A
in the
=0A
https://www.postgresql.org/do= cs/current/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT=0A
 
=0A
there is no description about these three par= ameters=E3=80=82
=0A
 
=0A
=0A= ------=_001_NextPart385407426340_=------