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 1nSdyL-0001Kc-Q1 for pgsql-bugs@arkaria.postgresql.org; Fri, 11 Mar 2022 12:02:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nSdyK-00059K-BB for pgsql-bugs@arkaria.postgresql.org; Fri, 11 Mar 2022 12:02:16 +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 1nSdBq-0003ns-P6 for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 11:12:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSdBn-0004NX-Am for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 11:12:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=2uSOzpvoqhOa7Ds8DHFXLlmJjOp4ayBDaeD4kQbifn8=; b=1+01wf6Hnm92F0zf6AWrCq9o87 zaBtoX1DJRx5b1698XHr1c17otEBXG3CT63ZiDx2VS/HqRODoAUpMx9Wao3neKuctP7vmJ+mWcHow MqphZpVXTcuMLt1WbwNlGnZwE0nX5MegBmFFOETuXiSD4/S7qh7cGY4Qom91o5qg8lcLWqG/kGMgn 1Sdomkwyye/e0YmXLBDgif2EC/BoT6uJB3YbGQlTIxmhOgwnypumdpZPYJ4BQ+JcAxI+OVcMp564l NFKKIxAWcjdjj/d2aKvY2v6ieiTDm+/LOlQgXtJY+Was5Q10oCcXImJE3q5FFSVTZyyIyor/aaOVW qdhzuuNQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSdBl-000429-FC for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 11:12:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nSdBh-0013tD-9L for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 11:12:02 +0000 Content-Type: multipart/mixed; boundary="===============0481022344417789791==" MIME-Version: 1.0 Subject: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: nagata@sraoss.co.jp Reply-To: nagata@sraoss.co.jp, pgsql-bugs@lists.postgresql.org Date: Fri, 11 Mar 2022 11:11:54 +0000 Message-ID: <17434-d9f7a064ce2a88a3@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0481022344417789791== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQzNApMb2dnZWQgYnk6ICAgICAgICAgIFl1Z28gTmFnYXRhCkVtYWls IGFkZHJlc3M6ICAgICAgbmFnYXRhQHNyYW9zcy5jby5qcApQb3N0Z3JlU1FMIHZlcnNpb246IDE0 LjIKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUKRGVzY3JpcHRpb246ICAgICAgICAKCkNSRUFU RS9EUk9QIERBVEFCQVNFIGNhbiBiZSBleGVjdXRlZCBpbiB0aGUgc2FtZSB0cmFuc2FjdGlvbiB3 aXRoIG90aGVyCmNvbW1hbmRzIHdoZW4gd2UgdXNlIHBpcGVsaW5lIG1vZGUgaW4gcGdiZW5jaCBv ciBsaWJwcSBBUEkuIElmIHRoZQp0cmFuc2FjdGlvbiBhYm9ydHMsIHRoaXMgY2F1c2VzIGFuIGlu Y29uc2lzdGVuY3kgYmV0d2VlbiB0aGUgc3lzdGVtIGNhdGFsb2cKYW5kIGJhc2UgZGlyZWN0b3J5 Lg0KDQpIZXJlIGlzIGFuIGV4YW1wbGUgdXNpbmcgdGhlIHBnYmVuY2ggL3N0YXJ0cGlwZWxpbmUg bWV0YSBjb21tYW5kLg0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tDQooMSkgIENvbmZpcm0gdGhhdCB0aGVyZSBhcmUgZm91ciBkYXRhYmFzZXMg ZnJvbSBwc3FsIGFuZCBkaXJlY3RvcmllcyBpbgpiYXNlLg0KDQokIHBzcWwgLWwNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIExpc3Qgb2YgZGF0YWJhc2VzDQogICBOYW1lICAgIHwg T3duZXIgIHwgRW5jb2RpbmcgfCAgIENvbGxhdGUgICB8ICAgIEN0eXBlICAgIHwgICBBY2Nlc3MK cHJpdmlsZWdlcyAgIA0KLS0tLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBwb3N0Z3JlcyAgfCB5 dWdvLW4gfCBVVEY4ICAgICB8IGphX0pQLlVURi04IHwgamFfSlAuVVRGLTggfCANCiB0ZW1wbGF0 ZTAgfCB5dWdvLW4gfCBVVEY4ICAgICB8IGphX0pQLlVURi04IHwgamFfSlAuVVRGLTggfCA9Yy8i eXVnby1uIiAgICAKICAgICArDQogICAgICAgICAgIHwgICAgICAgIHwgICAgICAgICAgfCAgICAg ICAgICAgICB8ICAgICAgICAgICAgIHwKInl1Z28tbiI9Q1RjLyJ5dWdvLW4iDQogdGVtcGxhdGUx IHwgeXVnby1uIHwgVVRGOCAgICAgfCBqYV9KUC5VVEYtOCB8IGphX0pQLlVURi04IHwgPWMvInl1 Z28tbiIgICAgCiAgICAgKw0KICAgICAgICAgICB8ICAgICAgICB8ICAgICAgICAgIHwgICAgICAg ICAgICAgfCAgICAgICAgICAgICB8CiJ5dWdvLW4iPUNUYy8ieXVnby1uIg0KIHRlc3QwICAgICB8 IHl1Z28tbiB8IFVURjggICAgIHwgamFfSlAuVVRGLTggfCBqYV9KUC5VVEYtOCB8IA0KKDQgcm93 cykNCg0KJCBscyBkYXRhL2Jhc2UvDQoxICAxMzAxNCAgMTMwMTUgIDE2NDA5ICBwZ3NxbF90bXAN Cg0KKDIpIEV4ZWN1dGUgQ1JFQVRFIERBVEFCQVNFIGluIGEgdHJhbnNhY3Rpb24sIGFuZCB0aGUg dHJhbnNhY3Rpb24gZmFpbHMuDQoNCiQgY2F0IHBpcGVsaW5lX2NyZWF0ZWRiLnNxbCANClxzdGFy dHBpcGVsaW5lDQpjcmVhdGUgZGF0YWJhc2UgdGVzdDsNCnNlbGVjdCAxLzA7DQpcZW5kcGlwZWxp bmUNCg0KJCBwZ2JlbmNoIC10IDEgLWYgcGlwZWxpbmVfY3JlYXRlZGIuc3FsIC1NIGV4dGVuZGVk DQpwZ2JlbmNoICgxNC4yKQ0Kc3RhcnRpbmcgdmFjdXVtLi4uZW5kLg0KcGdiZW5jaDogZXJyb3I6 IGNsaWVudCAwIHNjcmlwdCAwIGFib3J0ZWQgaW4gY29tbWFuZCAzIHF1ZXJ5IDA6IA0KLi4uLg0K DQooMykgVGhlcmUgYXJlIHN0aWxsIGZvdXIgZGF0YWJhc2VzIGJ1dCBhIG5ldyBkaXJlY3Rvcnkg d2FzIGNyZWF0ZWQgaW4KYmFzZS4NCg0KJCBwc3FsIC1sDQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBMaXN0IG9mIGRhdGFiYXNlcw0KICAgTmFtZSAgICB8IE93bmVyICB8IEVuY29k aW5nIHwgICBDb2xsYXRlICAgfCAgICBDdHlwZSAgICB8ICAgQWNjZXNzCnByaXZpbGVnZXMgICAN Ci0tLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogcG9zdGdyZXMgIHwgeXVnby1uIHwgVVRGOCAg ICAgfCBqYV9KUC5VVEYtOCB8IGphX0pQLlVURi04IHwgDQogdGVtcGxhdGUwIHwgeXVnby1uIHwg VVRGOCAgICAgfCBqYV9KUC5VVEYtOCB8IGphX0pQLlVURi04IHwgPWMvInl1Z28tbiIgICAgCiAg ICAgKw0KICAgICAgICAgICB8ICAgICAgICB8ICAgICAgICAgIHwgICAgICAgICAgICAgfCAgICAg ICAgICAgICB8CiJ5dWdvLW4iPUNUYy8ieXVnby1uIg0KIHRlbXBsYXRlMSB8IHl1Z28tbiB8IFVU RjggICAgIHwgamFfSlAuVVRGLTggfCBqYV9KUC5VVEYtOCB8ID1jLyJ5dWdvLW4iICAgIAogICAg ICsNCiAgICAgICAgICAgfCAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgICAgIHwgICAgICAg ICAgICAgfAoieXVnby1uIj1DVGMvInl1Z28tbiINCiB0ZXN0MCAgICAgfCB5dWdvLW4gfCBVVEY4 ICAgICB8IGphX0pQLlVURi04IHwgamFfSlAuVVRGLTggfCANCig0IHJvd3MpDQoNCiQgbHMgZGF0 YS9iYXNlLw0KMSAgMTMwMTQgIDEzMDE1ICAxNjQwOSAgMTY0MTEgIHBnc3FsX3RtcA0KDQooNCkg TmV4dCwgZXhlY3V0ZSBEUk9QIERBVEFCQVNFIGluIGEgdHJhbnNhY3Rpb24sIGFuZCB0aGUgdHJh bnNhY3Rpb24KZmFpbHMuDQoNCiQgY2F0IHBpcGVsaW5lX2Ryb3BkYi5zcWwgDQpcc3RhcnRwaXBl bGluZQ0KZHJvcCBkYXRhYmFzZSB0ZXN0MDsNCnNlbGVjdCAxLzA7DQpcZW5kcGlwZWxpbmUNCg0K JCBwZ2JlbmNoIC10IDEgLWYgcGlwZWxpbmVfZHJvcGRiLnNxbCAtTSBleHRlbmRlZA0KcGdiZW5j aCAoMTQuMikNCnN0YXJ0aW5nIHZhY3V1bS4uLmVuZC4NCnBnYmVuY2g6IGVycm9yOiBjbGllbnQg MCBzY3JpcHQgMCBhYm9ydGVkIGluIGNvbW1hbmQgMyBxdWVyeSAwOg0KLi4uDQoNCig1KSBUaGVy ZSBhcmUgc3RpbGwgZm91ciBkYXRhYmFzZXMgYnV0IHRoZSBjb3JyZXNwb25kaW5nIGRpcmVjdG9y eSB3YXMKZGVsZXRlZCBpbiBiYXNlLg0KDQokIHBzcWwgLWwNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIExpc3Qgb2YgZGF0YWJhc2VzDQogICBOYW1lICAgIHwgT3duZXIgIHwgRW5j b2RpbmcgfCAgIENvbGxhdGUgICB8ICAgIEN0eXBlICAgIHwgICBBY2Nlc3MKcHJpdmlsZWdlcyAg IA0KLS0tLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBwb3N0Z3JlcyAgfCB5dWdvLW4gfCBVVEY4 ICAgICB8IGphX0pQLlVURi04IHwgamFfSlAuVVRGLTggfCANCiB0ZW1wbGF0ZTAgfCB5dWdvLW4g fCBVVEY4ICAgICB8IGphX0pQLlVURi04IHwgamFfSlAuVVRGLTggfCA9Yy8ieXVnby1uIiAgICAK ICAgICArDQogICAgICAgICAgIHwgICAgICAgIHwgICAgICAgICAgfCAgICAgICAgICAgICB8ICAg ICAgICAgICAgIHwKInl1Z28tbiI9Q1RjLyJ5dWdvLW4iDQogdGVtcGxhdGUxIHwgeXVnby1uIHwg VVRGOCAgICAgfCBqYV9KUC5VVEYtOCB8IGphX0pQLlVURi04IHwgPWMvInl1Z28tbiIgICAgCiAg ICAgKw0KICAgICAgICAgICB8ICAgICAgICB8ICAgICAgICAgIHwgICAgICAgICAgICAgfCAgICAg ICAgICAgICB8CiJ5dWdvLW4iPUNUYy8ieXVnby1uIg0KIHRlc3QwICAgICB8IHl1Z28tbiB8IFVU RjggICAgIHwgamFfSlAuVVRGLTggfCBqYV9KUC5VVEYtOCB8IA0KKDQgcm93cykNCg0KJCBscyBk YXRhL2Jhc2UvDQoxICAxMzAxNCAgMTMwMTUgIDE2NDExICBwZ3NxbF90bXANCg0KKDYpIFdlIGNh bm5vdCBjb25uZWN0IHRoZSBkYXRhYmFzZSAidGVzdDAiLg0KDQokIHBzcWwgdGVzdDANCnBzcWw6 IGVycm9yOiBjb25uZWN0aW9uIHRvIHNlcnZlciBvbiBzb2NrZXQgIi90bXAvLnMuUEdTUUwuMjU0 MzUiIGZhaWxlZDoKRkFUQUw6ICBkYXRhYmFzZSAidGVzdDAiIGRvZXMgbm90IGV4aXN0DQpERVRB SUw6ICBUaGUgZGF0YWJhc2Ugc3ViZGlyZWN0b3J5ICJiYXNlLzE2NDA5IiBpcyBtaXNzaW5nLg0K LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQpE ZXRhaWxlZCBkaXNjdXNzaW9ucyBhcmUgaGVyZTsNCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3Jn L21lc3NhZ2UtaWQvMjAyMjAzMDExNTE3MDQuNzZhZGFhZWZhOGVkNWQ2YzEyYWMzMDc5QHNyYW9z cy5jby5qcAoK --===============0481022344417789791==--