Re: Drop role cascade ? - Mailing list pgsql-general

From Ron
Subject Re: Drop role cascade ?
Date
Msg-id db5db383-0c8f-4cb8-0c98-84c3f9504c74@gmail.com
Whole thread Raw
In response to Re: Drop role cascade ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Drop role cascade ?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Drop role cascade ?
Next
From: gzh
Date:
Subject: Re: An I/O error occured while sending to the backend