Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j091w-0006vv-BC for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Feb 2020 19:11:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j091v-00080e-3G for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Feb 2020 19:11:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j091u-00080W-Qr for pgsql-bugs@lists.postgresql.org; Fri, 07 Feb 2020 19:11:06 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1j091s-0004C9-Ii for pgsql-bugs@lists.postgresql.org; Fri, 07 Feb 2020 19:11:06 +0000 Content-Type: multipart/mixed; boundary="===============7300613927965476418==" MIME-Version: 1.0 Subject: BUG #16249: Partition pruning blocks on exclusively locked table partition To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: boekewurm+postgres@gmail.com Reply-To: boekewurm+postgres@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 07 Feb 2020 19:10:05 +0000 Message-ID: <16249-0008721939743475@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7300613927965476418== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjI0OQpMb2dnZWQgYnk6ICAgICAgICAgIE1hdHRoaWFzIHZkIE1lZW50 CkVtYWlsIGFkZHJlc3M6ICAgICAgYm9la2V3dXJtK3Bvc3RncmVzQGdtYWlsLmNvbQpQb3N0Z3Jl U1FMIHZlcnNpb246IDExLjUKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gU3RyZXRjaCwgUkRT CkRlc2NyaXB0aW9uOiAgICAgICAgCgpDUkVBVEUgVEFCTEUgdGVzdCAobnVtIGJpZ2ludCBVTklR VUUgUFJJTUFSWSBLRVkpIFBBUlRJVElPTiBCWSBSQU5HRQoobnVtKTsNCkNSRUFURSBUQUJMRSB0 ZXN0XzEwMCBQQVJUSVRJT04gT0YgdGVzdCBGT1IgVkFMVUVTIEZST00gKDApIFRPICgxMDApOw0K Q1JFQVRFIFRBQkxFIHRlc3RfMjAwIFBBUlRJVElPTiBPRiB0ZXN0IEZPUiBWQUxVRVMgRlJPTSAo MTAwKSBUTyAoMjAwKTsNCg0KSU5TRVJUIElOVE8gdGVzdCBTRUxFQ1QgKiBGUk9NIGdlbmVyYXRl X3NlcmllcygwLCAxOTksIDEpDQoNCi0tIHNxbCBjb25zb2xlIDENCg0KQkVHSU47DQpSRUlOREVY IFRBQkxFIHRlc3RfMTAwOw0KDQotLSBzcWwgY29uc29sZSAyDQoNCkJFR0lOOw0KLyogdGhlIGZv bGxvd2luZyBxdWVyaWVzIHJldHVybiBpbW1lZGlhdGVseSAqLw0KU0VMRUNUICogRlJPTSB0ZXN0 XzIwMCBXSEVSRSBudW0gYmV0d2VlbiAxMDEgQU5EIDEwNTsNClxkKyB0ZXN0DQpMT0NLIFRBQkxF IHRlc3QgSU4gQUNDRVNTIFNIQVJFIE1PREU7DQoNCi8qIHRoaXMgZG9lcyBub3QgcmV0dXJuIGEg cmVzdWx0IGltbWVkaWF0ZWx5OiBpdCBibG9ja3MgaW4gdGhlIHBsYW5uaW5nICovDQpTRUxFQ1Qg KiBGUk9NIHRlc3QgV0hFUkUgbnVtIEJFVFdFRU4gMTAxIEFORCAxMDU7DQovKg0KICBXaGVuIHdl IGZpbmFsbHkgY29tbWl0IC8gcm9sbGJhY2sgaW4gd2luZG93IDEsIHdlIGdldCB0aGUgZm9sbG93 aW5nCnJlc3VsdDoNCg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0NCiBBcHBlbmQgIChjb3N0PTAuMDAuLjIuNTIgcm93cz01IHdpZHRoPTgpIChh Y3R1YWwgdGltZT0wLjAwNy4uMC4wMTQgcm93cz01Cmxvb3BzPTEpDQogICAtPiAgU2VxIFNjYW4g b24gcHVibGljLnRlc3RfMjAwICAoY29zdD0wLjAwLi4yLjUwIHJvd3M9NSB3aWR0aD04KSAoYWN0 dWFsCnRpbWU9MC4wMDcuLjAuMDEzIHJvd3M9NSBsb29wcz0xKQ0KICAgICAgICAgT3V0cHV0OiB0 ZXN0XzIwMC5udW0NCiAgICAgICAgIEZpbHRlcjogKCh0ZXN0XzIwMC5udW0gPj0gMTAxKSBBTkQg KHRlc3RfMjAwLm51bSA8PSAxMDUpKQ0KICAgICAgICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjog OTUNCiBQbGFubmluZyBUaW1lOiA4MDg3Mi4wMDQgbXMNCiBFeGVjdXRpb24gVGltZTogMC4wMjYg bXMNCig3IHJvd3MpDQoqLw0KDQpJbiBteSBodW1ibGUgb3BpbmlvbiwgdGhpcyBxdWVyeSBzaG91 bGQgbm90IGJlIGJsb2NrZWQgZHVyaW5nIHBsYW5uaW5nLCBhcwp0aGUgcGFydGl0aW9uIGNhbiBi ZSBwcnVuZWQgZGlyZWN0bHkgZnJvbSB0aGUgcGxhbiB3aXRoIHRoZSBwYXJ0aXRpb24KaW5mb3Jt YXRpb24gdGhhdCBpcyBhdmFpbGFibGUgZnJvbSB0aGUgcGFyZW50IHRhYmxlOiBQYXJ0aXRpb24g aW5mb3JtYXRpb24KY2FuIGJlIHVwZGF0ZWQgIHdoZW4gdGhlIHBhcnRpdGlvbiBpcyBsb2NrZWQs IGJ1dCB0aHJvdWdoIHRoZSBwYXJlbnQKcGFydGl0aW9uZWQgdGFibGUuIA0KDQpFeGFtcGxlcyBo YXZlIGJlZW4gdGVzdGVkIG9uIGJvdGggRGViaWFuIGFuZCBBbWF6b24gUkRTLg0KDQpXaXRoIHJl Z2FyZHMsDQoNCk1hdHRoaWFzCgo= --===============7300613927965476418==--