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 1ovolc-00016t-CQ for pgsql-general@arkaria.postgresql.org; Thu, 17 Nov 2022 23:58:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ovola-0002FI-UY for pgsql-general@arkaria.postgresql.org; Thu, 17 Nov 2022 23:57:58 +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 1ovola-0002F2-KQ for pgsql-general@lists.postgresql.org; Thu, 17 Nov 2022 23:57:58 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ovolY-0003b7-Gb for pgsql-general@lists.postgresql.org; Thu, 17 Nov 2022 23:57:57 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 2AHNvqEL2062954; Thu, 17 Nov 2022 18:57:52 -0500 From: Tom Lane To: Ron cc: pgsql-general@lists.postgresql.org, Alvaro Herrera Subject: Re: Drop role cascade ? In-reply-to: <165fba28-443f-c981-ba06-a996b8c81969@gmail.com> References: <2058701.1668727016@sss.pgh.pa.us> <165fba28-443f-c981-ba06-a996b8c81969@gmail.com> Comments: In-reply-to Ron message dated "Thu, 17 Nov 2022 17:44:51 -0600" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2062952.1668729472.1@sss.pgh.pa.us> Date: Thu, 17 Nov 2022 18:57:52 -0500 Message-ID: <2062953.1668729472@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Ron writes: > On 11/17/22 17:16, Tom Lane wrote: >> Not directly, but see REASSIGN OWNED and DROP OWNED. > SIMULATE and VERBOSE options would be handy, to see what those commands > would actually do. Hmph. I'm surprised to realize that those commands don't produce trace output comparable to DROP CASCADE. If they did, this need would be met by the traditional hack of "BEGIN; DROP ...; ROLLBACK". regards, tom lane