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 1ovp1o-0001jj-M3 for pgsql-general@arkaria.postgresql.org; Fri, 18 Nov 2022 00:14:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ovp1n-0004Lg-JU for pgsql-general@arkaria.postgresql.org; Fri, 18 Nov 2022 00:14:43 +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 1ovp1n-0004LX-6X for pgsql-general@lists.postgresql.org; Fri, 18 Nov 2022 00:14:43 +0000 Received: from mail-qk1-x735.google.com ([2607:f8b0:4864:20::735]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ovp1k-0007Zo-Vx for pgsql-general@lists.postgresql.org; Fri, 18 Nov 2022 00:14:42 +0000 Received: by mail-qk1-x735.google.com with SMTP id 8so2459606qka.1 for ; Thu, 17 Nov 2022 16:14:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=9VkYqsfBo0fS9ulAkLCOtT7GkGvCGMht36kUAbs8StQ=; b=MS4gK5iiOhQ0oWfzgm56C0o4btIF1OZq/NOoqWYHhDXEnHAmoL8Slq6r/huUzVAwPe OM5PTFy7E0iza4rhBn1emUDRpOaxyaW0NHA+vyyD8oJI6BJKhvqYJGrKVrZnKIapBCrK UhdQ392c3zQXpgkX/+4WfLqE4OvI7LuRlK4inBoy09E/Eag+OnPC29cRTppy1MA0mCg4 jR3WYyn5iR8tsB/lOfCZGrkKc7wuSI0VR3jgi4lJ9QZ6rrz8Ait7e5tz32n/q/Rm4g8k TweMr3JOTA3hod+CsREREG/jVUEW2Jz21Y36pZBFrm+cRU4I8A5mOeumAUBd1I3UABrG QHzQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=9VkYqsfBo0fS9ulAkLCOtT7GkGvCGMht36kUAbs8StQ=; b=4enzq274oGMzPSKhVz+4lSNsga67GY82lfNF8EFdyX2od0OoYDAc2kNzEIzAZGE981 jy+pEhOj7ymAOvajpFixOJaypEYw+Ol7aA4KN4J5SDlCg2VsZgzQ3+0nAg+1zsXnnz4x oMTrnx/qAVTikfUYWI5/2c0HuvV01qZXdptnDhWCBqp0kKNdZ7noWAC0c47sppDsF0Nm H+wE/+6GnTJKf3zHIAnfrvbeJ/lsTUqLxm0jBvXlVUJ4KzelX5fPRXdGWPCJaFcAJqe0 x2FcOXumzE27q99yb0YPz4ABBobI9o9y8laV6IZBgRxf6FhK93vHaPlNUL9DRdfa+c3m pn3Q== X-Gm-Message-State: ANoB5plmmk8Md9YHhGXqtPREssmH6zvPflaxIvGkG8S0CexWcJtenTXR zvOHnMHjhsQ7sb5EF6/YMmMLFyuIXWI= X-Google-Smtp-Source: AA0mqf5I/rCzJnbrr5P0B6sm8rawt2PlepXMHofwqZ9XQ0K8nlYEbrdpZHXXbdHaFurp1IaqMN1d2Q== X-Received: by 2002:a05:620a:132c:b0:6fa:774:2822 with SMTP id p12-20020a05620a132c00b006fa07742822mr3983394qkj.410.1668730478409; Thu, 17 Nov 2022 16:14:38 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id o16-20020a05620a2a1000b006fab68c7e87sm1483434qkp.70.2022.11.17.16.14.37 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 17 Nov 2022 16:14:38 -0800 (PST) Message-ID: Date: Thu, 17 Nov 2022 18:14:37 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: Drop role cascade ? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <2058701.1668727016@sss.pgh.pa.us> <165fba28-443f-c981-ba06-a996b8c81969@gmail.com> <2062953.1668729472@sss.pgh.pa.us> From: Ron In-Reply-To: <2062953.1668729472@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/17/22 17:57, Tom Lane wrote: > 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". So... you'll add it to v16????  :D -- Angular momentum makes the world go 'round.