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 1neA3e-00042k-E5 for pgsql-admin@arkaria.postgresql.org; Tue, 12 Apr 2022 06:31:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1neA3d-0003wP-3J for pgsql-admin@arkaria.postgresql.org; Tue, 12 Apr 2022 06:31:21 +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 1neA3c-0003wG-Og for pgsql-admin@lists.postgresql.org; Tue, 12 Apr 2022 06:31:20 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1neA3a-0001ep-Q7 for pgsql-admin@lists.postgresql.org; Tue, 12 Apr 2022 06:31:20 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id B78EB3808AA; Tue, 12 Apr 2022 08:31:17 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pj4vwRUA4TkZ; Tue, 12 Apr 2022 08:31:17 +0200 (CEST) Received: from [192.168.178.189] (ip-037-201-154-253.um10.pools.vodafone-ip.de [37.201.154.253]) by rs.plausibolo.de (Postfix) with ESMTPSA id 468BD3805B0; Tue, 12 Apr 2022 08:31:17 +0200 (CEST) Message-ID: <6bfd5d91-bb06-1b56-f4f8-cc8f90307a35@jakobs.com> Date: Tue, 12 Apr 2022 08:31:15 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.8.0 Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: <548f2ed6-3209-705d-09e2-a5afbc6fb71c@quadratum-braccas.com> From: Holger Jakobs Subject: Re: set autocommit only for select statements In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------gg0DFnhwZyJIhTsDNboWCh8T" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------gg0DFnhwZyJIhTsDNboWCh8T Content-Type: multipart/mixed; boundary="------------L86RHO5YpIZ8zENGqjIHyecg"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <6bfd5d91-bb06-1b56-f4f8-cc8f90307a35@jakobs.com> Subject: Re: set autocommit only for select statements References: <548f2ed6-3209-705d-09e2-a5afbc6fb71c@quadratum-braccas.com> In-Reply-To: --------------L86RHO5YpIZ8zENGqjIHyecg Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMTIuMDQuMjIgdW0gMDM6NTMgc2NocmllYiBNbGFkZW4gR29nYWxhOg0KPg0KPiBUaGUg ImF1dG9jb21taXQiIGlzIGEgdG9vbCBvcHRpb24gd2hpY2ggdGVsbHMgdGhlIHRvb2wgd2hl dGhlciB0byBhZGQgDQo+ICJDT01NSVQiIHN0YXRlbWVudCBhZnRlciBlYWNoIGFuZCBldmVy eSBTUUwuIFRoZSBSREJNUyBzZXJ2ZXIgb25seSANCj4ga25vd3MgYWJvdXQgdHJhbnNhY3Rp b25zLCBhcyBtYW5kYXRlZCBieSB0aGUgQUNJRCBjb21wbGlhbmNlLiBXaGF0IHRoZSANCj4g ImF1dG9jb21taXQiIG9wdGlvbiBvZiB0b29scyBsaWtlIHBzcWwgYWN0dWFsbHkgZG9lcyBp cyB0byB0dXJuIGVhY2ggDQo+IG9mIHlvdXIgU1FMIHN0YXRlbWVudHMgaW50byBhIHNlcGFy YXRlIHRyYW5zYWN0aW9uLg0KPg0KV2hhdCB5b3Ugd3JpdGUgYWJvdXQgcHNxbCBzZW5kaW5n IGEgQ09NTUlUIHN0YXRlbWVudCBhZnRlciBlYWNoIA0Kc3RhdGVtZW50IGlzIHdyb25nLiBJ dCBtYXkgYmUgdHJ1ZSBmb3Igb3RoZXIgZGF0YWJhc2Ugc3lzdGVtcy4NCg0KUG9zdGdyZVNR TCBhcyBhIHNlcnZlciBjb21taXRzIGVhY2ggc3RhdGVtZW50IGF1dG9tYXRpY2FsbHkgdW5s ZXNzIHRoZSANCmNsaWVudCBoYXMgc3RhcnRlZCBhIHRyYW5zYWN0aW9uIHdpdGggQkVHSU4g b3IgU1RBUlQgVFJBTlNBQ1RJT04gc3RhdGVtZW50cy4NCg0KVGhpcyBjYW4gYmUgcHJvdmVk IGVhc2lseSBieSBub3QgdXNpbmcgcHNxbCBhcyBhIGNsaWVudCwgYnV0IHNvbWUgDQpwcm9n cmFtbWluZyBsYW5ndWFnZS4NCg0KUmVnYXJkcywNCg0KSG9sZ2VyDQoNCg0KLS0gSG9sZ2Vy IEpha29icywgQmVyZ2lzY2ggR2xhZGJhY2gsIFRlbC4gKzQ5LTE3OC05NzU5MDEyDQo= --------------L86RHO5YpIZ8zENGqjIHyecg-- --------------gg0DFnhwZyJIhTsDNboWCh8T Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYlUcswUDAAAAAAAKCRCKV5yTsxlhuqMf AKCSfqSw+FsBXNSwvVdD6oveo8bHkQCfaLSaq5rvj1O2owIC3f89eDaY3L4= =x4qe -----END PGP SIGNATURE----- --------------gg0DFnhwZyJIhTsDNboWCh8T--