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

From Tom Lane
Subject Re: Drop role cascade ?
Date
Msg-id 2062953.1668729472@sss.pgh.pa.us
Whole thread Raw
In response to Re: Drop role cascade ?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Drop role cascade ?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
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".

            regards, tom lane



pgsql-general by date:

Previous
From: Murillo corvino rocha
Date:
Subject: RES: session_user different from current_user after normal login
Next
From: Ron
Date:
Subject: Re: Drop role cascade ?