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 1ki2VN-0005Oa-Es for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Nov 2020 21:39:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ki2VL-0000Na-1Q for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Nov 2020 21:39:11 +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 1ki268-0002Hq-6s for pgsql-bugs@lists.postgresql.org; Wed, 25 Nov 2020 21:13:08 +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 1ki266-0002Cf-D8 for pgsql-bugs@lists.postgresql.org; Wed, 25 Nov 2020 21:13:07 +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=1kEGmS7m9uNi/Zz6ZrPFRYpQWZ4vVSqq0wjvX5dKM5w=; b=jzHAGToD/EjRbL7r1Jkz5dQpF4 IOfyfQCDxh24oU/okf1YSDknR4xavux9rRx19hNZonpYqcJT09+PL5DAmFOn9bffwgtE3ewY7mmSi mFW/l2wu5iFRVApPtk/SugQOZPvzm20E38gp82cDDWERmwr1sXuBoqgi8vMqV5Kd3heMdr9gDlqgZ KPx2rRk41zm17l6YUR/vQVCB/fEix5Kj3cYR0ZkT2f1po6gWFzC5QOC/HVa2kpCx8WSFy5qAauAJt UfbB8q7CGC+7cqrt4guxM+YD3el6XMgSYIwa1tbHNQXOPByXkf19E+GysxYUfhXAe7JxNt5ZD8CAa WeUqQK6A==; 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 1ki265-0003YN-10 for pgsql-bugs@lists.postgresql.org; Wed, 25 Nov 2020 21:13:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ki262-0006aT-6O for pgsql-bugs@lists.postgresql.org; Wed, 25 Nov 2020 21:13:02 +0000 Content-Type: multipart/mixed; boundary="===============3109472882252619910==" MIME-Version: 1.0 Subject: BUG #16745: delete does not prune partitions on declarative partitioned table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: akattunga@gmail.com Reply-To: akattunga@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 25 Nov 2020 21:12:49 +0000 Message-ID: <16745-e765ee2879fea695@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3109472882252619910== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc0NQpMb2dnZWQgYnk6ICAgICAgICAgIENocmlzdGlhbiBQcmFkZWxs aQpFbWFpbCBhZGRyZXNzOiAgICAgIGFrYXR0dW5nYUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMy4xCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1CkRlc2NyaXB0aW9uOiAgICAgICAg CgpUb2RheSBJIHVwZ3JhZGUgZnJvbSBQRy0xMiB0byBQRy0xMw0KDQpOb3cgSSBkZXRlY3QgdGhh dCBkZWxldGUgZG9lcyBub3QgcHJ1bmUgcGFydGl0aW9ucyBvbiBkZWNsYXJhdGl2ZQpwYXJ0aXRp b25lZCB0YWJsZS4NCg0KdGFibGUgc3RydWN0dXJlDQoNCkNSRUFURSBUQUJMRSBwdWJsaWMuZmFj X2l0ZW0NCigNCiAgICBmZmFjbnVtIGludGVnZXIgTk9UIE5VTEwsDQogICAgZmNvZGRpc3QgY2hh cmFjdGVyIHZhcnlpbmcoMTUpIENPTExBVEUgcGdfY2F0YWxvZy4iZGVmYXVsdCIsDQogICAgZnBy b21vYyBjaGFyYWN0ZXIgdmFyeWluZygxKSBDT0xMQVRFIHBnX2NhdGFsb2cuImRlZmF1bHQiLA0K ICAgIGZ2ZW5kZWQgY2hhcmFjdGVyIHZhcnlpbmcoMTUpIENPTExBVEUgcGdfY2F0YWxvZy4iZGVm YXVsdCIsDQogICAgZmNvZHBybyBjaGFyYWN0ZXIgdmFyeWluZygxNSkgQ09MTEFURSBwZ19jYXRh bG9nLiJkZWZhdWx0IiwNCiAgICBmZWFuIGNoYXJhY3RlciB2YXJ5aW5nKDE1KSBDT0xMQVRFIHBn X2NhdGFsb2cuImRlZmF1bHQiLA0KICAgIGZjYW50aWQgZG91YmxlIHByZWNpc2lvbiwNCiAgICBm dG90YWwgZG91YmxlIHByZWNpc2lvbiwNCiAgICBmZmVjaGFpIGRhdGUgTk9UIE5VTEwsDQogICAg ZmZlY2hhZiBkYXRlLA0KICAgIGZhcnR1bmkgaW50ZWdlciwNCiAgICBmaW1wbnVtIGludGVnZXIs DQogICAgZnN1Y3VycyBpbnRlZ2VyLA0KICAgIGZwcmVyZWYgbnVtZXJpYygxOCw2KSwNCiAgICBm Y2xpaW50IGludGVnZXIsDQogICAgZmRlc2N1ZSBkb3VibGUgcHJlY2lzaW9uLA0KICAgIGZ2ZW5w cmUgbnVtZXJpYygxOCw2KSwNCiAgICBDT05TVFJBSU5UIHBrX2ZhY19pdGVtIFBSSU1BUlkgS0VZ IChmZmFjbnVtLCBmZmVjaGFpKQ0KKSBQQVJUSVRJT04gQlkgUkFOR0UgKGZmZWNoYWkpOw0KDQpJ ZiBJIGV4ZWN1dGU6DQoNCnNlbGVjdCAqIEZST00gRkFDX0lURU0gV0hFUkUgRkNPRERJU1Q9Jycg QU5EIEZTVUNVUlM9MSBBTkQKRkZFQ0hBST1jdXJyZW50X2RhdGU7DQoNCml0IHVzZSBvbmx5IG9u ZSBwYXJ0aXRpb24NCg0KYnV0Og0KDQpkZWxldGUgRlJPTSBGQUNfSVRFTSBXSEVSRSBGQ09ERElT VD0nJyBBTkQgRlNVQ1VSUz0xIEFORApGRkVDSEFJPWN1cnJlbnRfZGF0ZTsNCg0Kc2NhbiBhbGwg cGFydGl0aW9ucw0KDQpJcyB0aGVyZSBhbnkgcmVncmVzc2lvbj8KCg== --===============3109472882252619910==--