From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Drop role cascade ?
Date: Thu, 17 Nov 2022 18:14:37 -0600
Message-ID: <db5db383-0c8f-4cb8-0c98-84c3f9504c74@gmail.com> (raw)
In-Reply-To: <2062953.1668729472@sss.pgh.pa.us>
References: <CAEs=6D=z_1f_FNS6NxYOpS-M8HrrKLmSoM=UY3yA6dznOivt0Q@mail.gmail.com>
<2058701.1668727016@sss.pgh.pa.us>
<165fba28-443f-c981-ba06-a996b8c81969@gmail.com>
<2062953.1668729472@sss.pgh.pa.us>
On 11/17/22 17:57, Tom Lane wrote:
> Ron <ronljohnsonjr@gmail.com> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ronljohnsonjr@gmail.com
Subject: Re: Drop role cascade ?
In-Reply-To: <db5db383-0c8f-4cb8-0c98-84c3f9504c74@gmail.com>
References: <CAEs=6D=z_1f_FNS6NxYOpS-M8HrrKLmSoM=UY3yA6dznOivt0Q@mail.gmail.com> <2058701.1668727016@sss.pgh.pa.us> <165fba28-443f-c981-ba06-a996b8c81969@gmail.com> <2062953.1668729472@sss.pgh.pa.us> <db5db383-0c8f-4cb8-0c98-84c3f9504c74@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox