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 1qDhhT-0002FT-7f for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Jun 2023 08:35:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qDhhR-0002vE-LH for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Jun 2023 08:35:53 +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 1qDhhR-0002v4-CO for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 08:35:53 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qDhhP-000Y8U-1X for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 08:35:52 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 378D95C00B5; Mon, 26 Jun 2023 04:35:50 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Mon, 26 Jun 2023 04:35:50 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1687768550; x=1687854950; bh=ZP JNW+FTeDrgN5upP085QvnN/9aUE1sKjQ2m6gb9rx0=; b=s3iVsq6I7w/Qo7jmn7 hxHpbYxCRUgOpqBInPxdplP/KEndiKItp0+XhcualebB+USNkjOUZUykOoBWTMPh clfZSLNu6OYzf4KhBBzGm0AMnXBlzZkOf5KP5y/W3nffBVIj6WrOgWasTx/LxL64 At10s/JAfvKb9zlfmeTr7q9zejgjivTDuUaCwqi5YcOnKHOYlyKywVdvAjDD7NEG XC/OomIj2E0VDbqvY+7hjbtlqsKDGANecSq9B67p18Cz+sjIt09Qb7864CSUpgR2 IwQJ/vpppOcT1qy5dAC3v5WOFv8ejMYQSFg8WvgUQahFbEyJ2hJ7HS+zGu+/QXpx 17ow== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; t=1687768550; x=1687854950; bh=ZPJNW+FTeDrgN 5upP085QvnN/9aUE1sKjQ2m6gb9rx0=; b=DuLfxSV66GZ1EBUcGoKrGwHs+sjrg AMpVIdwtSaUS25UXjZo6OylFODT/0hfCP8Sh7YRiv784CW9gn5kiyjKwrsnDIGfe hzA6hsAgQiFtRWg53Ui7oAb6cBWwjnL4/FWOTBMSnLaSmgDkiuTia22WnDh0cokE LFm/juUth8ceVQs/2Qvzlitjw12yXOaS5Gnx+v6VRa4fv2sOjCWFAq5hQaS+fbMW NrkN+/DNz8yIJlzT1EdNOhW1qre+3bYlP9V0BuXweQ5GSRi7utAQgEkachRWB0Jo g2V7nWHNsSzwRa4WeqI2Iw/4jeUwT78QPY+H7wQMHUFzBQtBHI2+BTn2Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrgeehfedgtdefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrh hnpedvgeduuefhtdeuleettdevjeehheeiveeuieegleetgeeljeelieeuieehgeevhfen ucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthh grvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 26 Jun 2023 04:35:48 -0400 (EDT) Date: Mon, 26 Jun 2023 17:35:44 +0900 From: Michael Paquier To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18000: Access method used by matview can be dropped leaving broken matview Message-ID: References: <18000-9145c25b1af475ca@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="6O7yNL/adYWat2AL" Content-Disposition: inline In-Reply-To: <18000-9145c25b1af475ca@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --6O7yNL/adYWat2AL Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Jun 26, 2023 at 08:00:01AM +0000, PG Bug reporting form wrote: > But if the access method was set during a matview creation, it's deletion > is > prevented as expected: > CREATE ACCESS METHOD heap2 TYPE TABLE HANDLER heap_tableam_handler; > CREATE MATERIALIZED VIEW heapmv USING heap2 AS SELECT 1::int; > DROP ACCESS METHOD heap2; > ERROR: cannot drop access method heap2 because other objects depend on it > DETAIL: materialized view heapmv depends on access method heap2 > HINT: Use DROP ... CASCADE to drop the dependent objects too. >=20 > Reproduced on REL_15_STABLE .. master. Thanks for the report! ALTER TABLE .. SET ACCESS METHOD is on me. Will look.. -- Michael --6O7yNL/adYWat2AL Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmSZTeAACgkQnvQgOdby QH27/A/9EQ57zJe4pTtF6/i7kn3YDRAhJ8WsEc/FvVoy1XTWg7+j0wEUCtW141LX aac2jpTAYVmKKXHiRJLbeq9RBnu3bCZJAJF+hbxDaTG5dgoKbb4Q6bEET0RXhLDV B0C7kTkWQcR6J7WlWCXoS6MkjJ+Wf0XscF21eg7WGxUeLgd+w0EonVGOw3/KUZaX rAnGtdB7beaPe5x52TIyzyPmkurpvVvbO4MuaNIjOBlbJfygt7UWjkEjlB1/96v3 0S5XDnp6HOKPgTWSiZTYrfRDo6ka0bKIfIP90mDXOjb63bhxUhOKEIquUk4ruMdr EC/sFkfA2mSq0R6B5bKGXqEUplQQYqTzgsKmFel0TTiLQgnsL7gZsqgkwmLpQA55 ADM5/w4l2rIAnuE4p+doGuzDBrKFn8qHyHlgmAElb5Pg6Jt3sT8KVb1V+pMBLIGl Dj85OwBJw+ahG+rpnWoUexOP1pQsIMUqLk1ERFzBPZilaTp5TV0v8Z2DD6nSsU+m QeJ+hXR2M2xRTJdXepprKVPSgEKFpGhjfr+E7OBKWUSvvSMTbjw+I63AgvHtSen5 mdexQ75Ytaogo8HErtDaJA8Ik6mlvMQSJG2X84jFNqYF1uxHLIX/+EHkL4TtNC7r KAMl/lRMoASWHyRBOUls+MVuodN324qv5szS3ngtcHSCjuQj8bA= =dDfJ -----END PGP SIGNATURE----- --6O7yNL/adYWat2AL--