Re: Drop role cascade ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Subject: Re: Drop role cascade ?
Date: 2022-11-17 23:57:52
Message-ID: 2062953.1668729472@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron <ronljohnsonjr(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-11-18 00:14:37 Re: Drop role cascade ?
Previous Message Murillo corvino rocha 2022-11-17 23:53:18 RES: session_user different from current_user after normal login