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 1qLrFi-000q4L-Lu for psycopg@arkaria.postgresql.org; Tue, 18 Jul 2023 20:24:58 +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 1qLrFh-00D7sg-7c for psycopg@arkaria.postgresql.org; Tue, 18 Jul 2023 20:24:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qLrFg-00D7oC-Or for psycopg@lists.postgresql.org; Tue, 18 Jul 2023 20:24:57 +0000 Received: from mail-am0eur02on20621.outbound.protection.outlook.com ([2a01:111:f400:fe13::621] helo=EUR02-AM0-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qLrFd-000BkN-IC for psycopg@postgresql.org; Tue, 18 Jul 2023 20:24:55 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Hb0W9fi/FtHS2nPqkzIf6h3nC6az+me2i6O0DzKJl09iiCo+LkH1La27IxvPmY0y6I8E53gUtdMc7wk73aGEybXhmP++Yxu64KjF9zUIrqMLsuBWiFGJx3jteRTBgYD3WMwU14l0R3kTt8rExlUYnldBQwUXov0oc+aqzNFq2C5K4xE1sewlO2ye0h/K/LFpL0HdMMjRS8N8w+/eIy95LQDlMAdXLrwk0G1BhruPz0FPYq+3MUHfsfRppxASj5Rajiszz78+rQ6xTfGixcYmfoF7kgb6GyuSQfCjuK0tzPBFDHu7KZcJqLG8X6wsr0QmlsY8dj2BPViGx+UlyA0xJA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=d1Tipq5cbYLzPC+QE+UiU3tckppTv5KKUn7CIasreu4=; b=nafaclberCImAZU5fwMX/rz3qwFMT8OZD274Z8G2lfKdCEeY0nhFGUgwW9s1sTtu/Dr5GnbDAW+DBPlQ5TqcKtmVq4M2qkz3t69DlhlSxX+ptrXQuSPEnntUjhCD8eJ/2aWDTV4Ve0awTphZuhoAiu1tz9CDnVV6e1o0GtRk2riasq2L+UBpTMrZc3PsBxmnUgGqWwO1Io6rz+atry09+9wSunsFgT6nCNcgzEatrY5swCXHaZ9fJMczN9dquX7AdiJLHj+99vCxR3oBKsTN88OfyqnyXAPHRxVfExt5JjI/wotov0w+7Fv94Iy2tX4DMpQ8jLCy96XGMysyvsfkgg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=tomtom.com; dmarc=pass action=none header.from=tomtom.com; dkim=pass header.d=tomtom.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tomtom.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=d1Tipq5cbYLzPC+QE+UiU3tckppTv5KKUn7CIasreu4=; b=fSPUOZxuAcKrgoJ4pUJnCjC9/BZuDB4r07fF7DBcNbHcKeRp3Hq4oN8akuyq6YYsHVzSlDautNq91uv6iW6iW4xQZyMdOdDdpuCnpo/HkaNMqhReIhigF9z1n/NMaDPnWS+8YMasprrwAXNaIvxfq+0yYiowcjxgZxnLf7rTCzg= Received: from DB7PR07MB3916.eurprd07.prod.outlook.com (2603:10a6:5:7::33) by DU2PR07MB9521.eurprd07.prod.outlook.com (2603:10a6:10:49f::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6588.31; Tue, 18 Jul 2023 20:24:46 +0000 Received: from DB7PR07MB3916.eurprd07.prod.outlook.com ([fe80::bd04:b99b:f974:1899]) by DB7PR07MB3916.eurprd07.prod.outlook.com ([fe80::bd04:b99b:f974:1899%7]) with mapi id 15.20.6588.031; Tue, 18 Jul 2023 20:24:46 +0000 From: David Raymond To: Psycopg Subject: conn.read_only not honored in autocommit mode Thread-Topic: conn.read_only not honored in autocommit mode Thread-Index: Adm5rv7oy5B9avc0RryFFDGW+9RcaQ== Date: Tue, 18 Jul 2023 20:24:46 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=tomtom.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DB7PR07MB3916:EE_|DU2PR07MB9521:EE_ x-ms-office365-filtering-correlation-id: 3d480050-50f7-466d-6692-08db87cd075c x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: /bIWm5UmJ4jULsaJ3Pnv0cObGc5YnGHhV71OLhXrrKvhxRLD9n9CjAfUHHYNQSZVGaVJT8Kmb/9uNGAy3gk96ReAzFiv0oUQ+YZJPl6tGWk1syoMw1BZOldFXDiWb7e3M9Vz9zi0ZHuVewQe9UceSqU/PRIndM67sLxeY0Buuh/QVZ3wVmwpDLYj8pTc/dEQeZc+6ZXSSdmj/HZKohSI/93rKUHI+EaPlzcVB6vy4u0Tor/VLwmIGxSerE4Jo+8oq0nfPMtMXN+QfhMLBYwr0kz5yZQmdTe/pe3p5m4uDa2OJzeSaaPF0l8YJxIZ4j9WLznCV/vUPHLjo4dXxcDFL9f+M8b8ch6hZxTjzCDjorCBT0ZKLD5Qo9tu/0XMWqk3MwfivFpOGTcs6daLH4ljyWNwcuY9ab3W5MdSR28Dm4S2pmry6hw+bYAD6LSSCpryR/43Nr8m4gt2zgakgm5CQEVMA5d59O9GHAqDestLh42m67Ln/9MhOatV/hsX7KLMgU38ThGldHQelJCKCNP+nfhTJPSduJCOK0C9wlvd8HbljB4Psm7dmiGl2+OzPqjdp15r/tZujBl7H7ZjVS82vMPWq3PGiMLvrS9DY7Qu9Jrnc4PHVsGkB8ecn0x6K9f+QrgxLw6973y6h/JGNo3X1ir0CHoGed0E3saSxX5BaDA= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DB7PR07MB3916.eurprd07.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230028)(4636009)(376002)(366004)(39850400004)(346002)(136003)(396003)(451199021)(55016003)(122000001)(71200400001)(7696005)(478600001)(86362001)(8936002)(5660300002)(8676002)(52536014)(2906002)(38070700005)(33656002)(6916009)(38100700002)(76116006)(66476007)(64756008)(66556008)(66946007)(66446008)(41300700001)(316002)(26005)(6506007)(83380400001)(9686003)(186003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?MzJVWCsxVnRERFUzbWs0T3R2NmVVK2dLSGJwWm1aNkxQTVpSZFFXdU5tY1Bs?= =?utf-8?B?emxrNjJ0TXg2a09UbG5NQzJXVHczVUxhWmh0RWQzSGFIbHZGeWxjZTJKRENN?= =?utf-8?B?dGxTVE82QjZDTU0rQlhTTml1RGN6SXJKZnUvSGtubDFwNHJnd3FrZXAvMEt2?= =?utf-8?B?REM0V0JSakNqS0FHaHpUVkhHTzlLV1NhS0xsMWswdkhPRGlWR2xnTGJzL2Q4?= =?utf-8?B?SlZQVHZCeXRLM2M0dEdWZnhmeXI2dDdyVlN2UHVGSnIvMlFuU1lvQ2dhRFc1?= =?utf-8?B?SFNUSXpWcEJjLysyaExuWG5rRnJXQ0p4em5iU3dTcFNYVjhWVVBoa0hqV2Fi?= =?utf-8?B?NDRncFQzMjZibUxaME5FYXl3NXRPZXdMbUFUU010K3R4QWNpV1BWMHdLbm1U?= =?utf-8?B?TXo2d0pJbk1Ua3d2ZTVPc20xRVVZY1ZQM1RhVEp4WnVoZEVPdXozTFQ2ekpI?= =?utf-8?B?dVNDbXR6ckRGdUtXM29HdTZQeGxKbXc0WUh0NlF1ekpSSXZiUm5yc1dQWTlH?= =?utf-8?B?c3N4ckowTSt5WHo3d2tNSk16QWFGeml1TW4zMXRNRDYyQ3VYa0V6d3gvWGNw?= =?utf-8?B?UE13aGtmL2h6aiszRGhGSUNVZUJMN3ByTG5ZMUFVaGFYQ08zdFkyZzVCamJ6?= =?utf-8?B?cmYvUXlBc1dzbFduK09XWmxOVjRjRUVackZ1ZUtzdGxOMEMvL0NuTDRZU0NL?= =?utf-8?B?ZG9kVW1nSUh1RkN0UVhXZm5tNk0xUDFYc2Q2Y1lGWFhoSTBQUU9nTUk0UFBU?= =?utf-8?B?SlNvUStrYnFiTXFqaEdtcEx5QjU1NmRGanpxM29YQUlic0NNc3IwcXBxT1Rz?= =?utf-8?B?V1AyaFZpY0xFMjJZNjB0WlpaNnNNZng4MjJnMHNPUUlsV3VUS0pVcVFzQ2g4?= =?utf-8?B?SG1DNnU4VEp3RWJDakk4ZlZ6L1B5UjMxcGtlSi80WWpiVWpZS0RnWCt1YWZD?= =?utf-8?B?bkE1bGlQUFc0RUplV2M3VkYyOFRJbjFXSWVZUGZXbXdZaG5Dc1QxVE5CWG9W?= =?utf-8?B?eDJYZnRmTlZyZXM5ZU1uMWhISjdkL1FQeGpmaWVnalQ2T2ZMdklJcjJmL1NI?= =?utf-8?B?SWZvWloyOE9NQjdYZEJmZnFvODkvS1ZRQ3hYNHU1MXczRzNwbEt0RHdFcTQr?= =?utf-8?B?OVU4ZmtMa01qVWU5cXB5VnZNckU3Q1o5R2E1QWpYVEZZeHByRjVyRi9mVmxI?= =?utf-8?B?RStpU2EyMldjcXlZc2lyNmtWSWdjc0dMaW1xakphMVJySFQ1YjZYQmk1WUJZ?= =?utf-8?B?M1E0OHBIVmIxNW5xK0xUTnZ1ZGxMSE1YYUswenc1SnZrNW93eVY3d3JHbGI0?= =?utf-8?B?cTNwb3lOKzdGYXdNYTRMQkw2Uk53M3FBcE9tSWIwbHBhUDk3WHg2Y0cyRkZV?= =?utf-8?B?QXJ5TlZCc0V3WWRDSHlaRmp3R2ZpUlRta1IzbytqbmM4TFRsQXd0M2NKamRx?= =?utf-8?B?RkE1bDBrVjJIRVFodnk0YStkV2JOdWRoWnhieWRKamNhbmY5UkRGVmhSTHpi?= =?utf-8?B?VzRiZ2pPdElWVG9ZblprNWlTM29Lc1dhbzg0c3B1YWJDNGtKUzJnU01lWGQv?= =?utf-8?B?ZUE0MGRIcGVlS0NhUmRwbnF3aHlaeURheGs5eWxnQlMxU1FPMkxPeHRHYi9j?= =?utf-8?B?SDkwTTMxK2MrNFp0UnVHT1BQQlhHVWRKUFU3WDZqMHJDUkEvNXRESjZaZE1B?= =?utf-8?B?NHRWSG1vZjhDN0pybVJ1eXBXQXI0R2c2MXhHSkVla2o3UGJFWnpDdGIyNVpy?= =?utf-8?B?RmFjSG1wMUZnV3g2NHBrZ1BGMUJHdWpZZ1loemRtZjdkcDlLYzA0YlRtT3Yr?= =?utf-8?B?R2M2OVhRVzR1Rk9vbmo2Uko3NDZvRjBacnlBWUJMMlNqSGNiMEFVNG82cC9I?= =?utf-8?B?MkxLYTU4cHVtQ1JicDNlaVpnT0JTalg2aUFERi9laGFHSXRqMU9DWmx3bkov?= =?utf-8?B?K1YzeHErM1dOUHQzbXVCaUw2RS9IMWlBeU5xV3ZCdko0L1VrVHBQOVFmYWtK?= =?utf-8?B?ZEluNlB1VTNhYkwwL2xsOFBWcWZuWUh4NnZKWVM0aGQwTVdkZFhIWFRJdWl3?= =?utf-8?B?U0tOdFJWdGZXb0tuTHB5a2M5VmNnM3IwOVhBVk5uUTcxK0NnMW04TFJIMWxq?= =?utf-8?Q?UKQA1+chSn6h9Fi8tl8Pzd6Ou?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: tomtom.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DB7PR07MB3916.eurprd07.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 3d480050-50f7-466d-6692-08db87cd075c X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Jul 2023 20:24:46.4406 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 374f8026-7b54-4a3a-b87d-328fa26ec10d X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: xH94varYPhv/K7lqQM7ywYXaARYcP+wYM6afDlZtBe94gax6E9S9ooe9xaCqDR2iP+mckQrgS9woPSJNTKWz1YOfmc+VLF9wUVPorhKI6vg= X-MS-Exchange-Transport-CrossTenantHeadersStamped: DU2PR07MB9521 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SXQgYXBwZWFycyB0aGF0IHRoZSAucmVhZF9vbmx5IGF0dHJpYnV0ZSBvZiBhIGNvbm5lY3Rpb24g aXMgbm90IGhvbm9yZWQgd2hlbiB0aGUgY29ubmVjdGlvbiBpcyBpbiBhdXRvY29tbWl0IG1vZGUu DQoNClRoZXJlJ3Mgbm8gbWVudGlvbiBvZiB0aGlzIG9uIHRoZSBDb25uZWN0aW9uIGNsYXNzZXMg cGFnZSBmb3IgcmVhZF9vbmx5LCBhbmQgaW4gdGhlIHNlY3Rpb24gbGlua2VkIHRvIGluIFRyYW5z YWN0aW9ucyBtYW5hZ2VtZW50IHlvdSBoYXZlIHRvIHJlYWQgaXQgMyB0aW1lcyB0byByZWFsaXpl IGl0J3Mgb25seSB1c2VkIHdpdGggQ29ubmVjdGlvbi50cmFuc2FjdGlvbigpLg0KDQpJcyBpdCB0 aGUgaW50ZW50IHRvIG5vdCBiZSB1c2VkIGZvciByZWd1bGFyIGF1dG9jb21taXQgY29ubmVjdGlv bnMsIG9yIGlzIGl0IGFuIG92ZXJzaWdodD8NCg0KSSB1c2VkIGNvbm4uc2V0X3Nlc3Npb24ocmVh ZG9ubHkgPSBUcnVlLCBkZWZlcnJhYmxlID0gRmFsc2UsIGF1dG9jb21taXQgPSBUcnVlKSBpbiBw c3ljb3BnMiwgYW5kIHRoYXQgc2VlbWVkIHRvIHdvcmsgYXQgcHJldmVudGluZyBhY2NpZGVudGFs IGNoYW5nZXMuDQpJJ3ZlIGp1c3QgYmVlbiBtb3ZpbmcgdG8gcHN5Y29wZyByZWNlbnRseSwgYW5k IHdpdGggbm8gc2V0X3Nlc3Npb24gSSByZXBsYWNlZCBpdCB3aXRoIHB1dHRpbmcgYXV0b2NvbW1p dCA9IFRydWUgaW4gdGhlIGNvbm5lY3Rpb24gY2FsbCBhbmQgZm9sbG93aW5nIGl0IHdpdGggLnJl YWRfb25seSA9IFRydWUgYW5kIC5kZWZlcnJhYmxlID0gRmFsc2UNCg0KU2luY2UgSSB2YXN0bHkg cHJlZmVyIGF1dG9jb21taXQgbW9kZSwgaXMgbXkgYmVzdCBiZXQgdGhlbiB0byByZXBsYWNlDQpj b25uLnJlYWRfb25seSA9IFRydWUNCndpdGggZWl0aGVyDQpjb25uLmV4ZWN1dGUoInNldCBzZXNz aW9uIGNoYXJhY3RlcmlzdGljcyBhcyB0cmFuc2FjdGlvbiByZWFkIG9ubHksIG5vdCBkZWZlcnJh YmxlOyIpDQpvcg0KY29ubi5leGVjdXRlKCJzZXQgZGVmYXVsdF90cmFuc2FjdGlvbl9yZWFkX29u bHkgdG8gdHJ1ZTsiKQ0KY29ubi5leGVjdXRlKCJzZXQgZGVmYXVsdF90cmFuc2FjdGlvbl9kZWZl cnJhYmxlIHRvIGZhbHNlOyIpDQo/DQoNCihIb25lc3RseSBpbiBteSBtaW5kIEkgdGhvdWdodCB0 aGlzIGlzIHdoYXQgY2hhbmdpbmcgLnJlYWRfb25seSwgLmRlZmVycmFibGUsIG9yIC5pc29sYXRp b25fbGV2ZWwgZGlkIGluIHRoZSBiYWNrZ3JvdW5kIGFscmVhZHkpDQoNCg0KVGhhbmsgeW91IGZv ciB5b3VyIHBhdGllbmNlIHdpdGggbWUsDQo=