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 1qDhYk-0001fU-E5 for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Jun 2023 08:26:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qDhYj-00083B-AF for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Jun 2023 08:26:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qDh8v-0004O8-QK for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 08:00:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qDh8o-000Vaw-7n for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 08:00:12 +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=6BM55PxjDrkNYvUuEbER99NclshRSKVMf1tNtCRVO98=; b=toJsIV7Mm2Pkc5SN2MzpR96sU8 hH5kvCYEOvSD0pDJOBnUY+FqoglMR02LrAeCbodJcY5HRdIy9Q3qqtIiu7T7dGBbICoYFX++lfMfz LM5uTXQxCUccKmZALQ7lcYWuOXtKZPM5VM6AgvOBQqiQEMIePTt1+u45WhjWJ0iwhYRieXdYw5eRl JiH6BUp8JX+I+r+ULRBds2HvAfi13sie2CtjnocaUOB0tEKF8SWbK8xNg/zU9IjnHc/36w6TEFUgv AAEgEwe6wxrU2ggB+OzMCTEPFqgnxbgann+8JzO0M8mcg/gLyufYN56bnx2UX9C4keTPpRfP7WF1V ut2r7nRA==; 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 1qDh8n-0005LO-Av for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 08:00: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 1qDh8k-001YCJ-UN for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 08:00:03 +0000 Content-Type: multipart/mixed; boundary="===============0653160593231706568==" MIME-Version: 1.0 Subject: BUG #18000: Access method used by matview can be dropped leaving broken matview To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 26 Jun 2023 08:00:01 +0000 Message-ID: <18000-9145c25b1af475ca@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 --===============0653160593231706568== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODAwMApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTZiZXRhMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjog ICAgICAgIAoKVGhlIGZvbGxvd2luZyBzY3JpcHQ6DQpCRUdJTjsNCkNSRUFURSBBQ0NFU1MgTUVU SE9EIGhlYXAyIFRZUEUgVEFCTEUgSEFORExFUiBoZWFwX3RhYmxlYW1faGFuZGxlcjsNCkNSRUFU RSBNQVRFUklBTElaRUQgVklFVyBoZWFwbXYgVVNJTkcgaGVhcCBBUyBTRUxFQ1QgMTo6aW50Ow0K QUxURVIgTUFURVJJQUxJWkVEIFZJRVcgaGVhcG12IFNFVCBBQ0NFU1MgTUVUSE9EIGhlYXAyOw0K RFJPUCBBQ0NFU1MgTUVUSE9EIGhlYXAyOw0KU0VMRUNUICogRlJPTSBoZWFwbXY7DQpDT01NSVQ7 DQpTRUxFQ1QgKiBGUk9NIGhlYXBtdjsNCkRST1AgTUFURVJJQUxJWkVEIFZJRVcgaGVhcG12Ow0K DQpkcm9wcyB0aGUgYWNjZXNzIG1ldGhvZCBoZWFwMiwgYnV0IGxlYXZlcyB0aGUgbWF0ZXJpYWxp emVkIHZpZXcgaGVhcG12LA0Kd2hpY2ggdGhlbiBjYW4gbm90IGJlIGFjY2Vzc2VkIG5vciBkcm9w cGVkOg0KRVJST1I6ICBjYWNoZSBsb29rdXAgZmFpbGVkIGZvciBhY2Nlc3MgbWV0aG9kIDE2Mzkw DQoNCllvdSBjYW5ub3QgZHVtcCB0aGUgZGF0YWJhc2UsIHRvbzoNCnBnX2R1bXA6IGVycm9yOiBx dWVyeSBmYWlsZWQ6IEVSUk9SOiAgY2FjaGUgbG9va3VwIGZhaWxlZCBmb3IgYWNjZXNzIG1ldGhv ZAoxNjM5MA0KcGdfZHVtcDogZGV0YWlsOiBRdWVyeSB3YXM6IFNFTEVDVApwZ19jYXRhbG9nLnBn X2dldF92aWV3ZGVmKCcxNjM5MSc6OnBnX2NhdGFsb2cub2lkKSBBUyB2aWV3ZGVmDQoNCkJ1dCBp ZiB0aGUgYWNjZXNzIG1ldGhvZCB3YXMgc2V0IGR1cmluZyBhIG1hdHZpZXcgY3JlYXRpb24sIGl0 J3MgZGVsZXRpb24KaXMNCnByZXZlbnRlZCBhcyBleHBlY3RlZDoNCkNSRUFURSBBQ0NFU1MgTUVU SE9EIGhlYXAyIFRZUEUgVEFCTEUgSEFORExFUiBoZWFwX3RhYmxlYW1faGFuZGxlcjsNCkNSRUFU RSBNQVRFUklBTElaRUQgVklFVyBoZWFwbXYgVVNJTkcgaGVhcDIgQVMgU0VMRUNUIDE6OmludDsN CkRST1AgQUNDRVNTIE1FVEhPRCBoZWFwMjsNCkVSUk9SOiAgY2Fubm90IGRyb3AgYWNjZXNzIG1l dGhvZCBoZWFwMiBiZWNhdXNlIG90aGVyIG9iamVjdHMgZGVwZW5kIG9uIGl0DQpERVRBSUw6ICBt YXRlcmlhbGl6ZWQgdmlldyBoZWFwbXYgZGVwZW5kcyBvbiBhY2Nlc3MgbWV0aG9kIGhlYXAyDQpI SU5UOiAgVXNlIERST1AgLi4uIENBU0NBREUgdG8gZHJvcCB0aGUgZGVwZW5kZW50IG9iamVjdHMg dG9vLg0KDQpSZXByb2R1Y2VkIG9uIFJFTF8xNV9TVEFCTEUgLi4gbWFzdGVyLgoK --===============0653160593231706568==--