Re: LIST OWNED BY... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: LIST OWNED BY...
Date
Msg-id 3097.1330535767@sss.pgh.pa.us
Whole thread Raw
In response to LIST OWNED BY...  (Thom Brown <thom@linux.com>)
Responses Re: LIST OWNED BY...  (Thom Brown <thom@linux.com>)
List pgsql-hackers
Thom Brown <thom@linux.com> writes:
> So could we introduce either a command to show which objects are owned
> by a particular role, or allow a dry-run of DROP OWNED BY?

It's always been possible to do that:
begin;drop owned by joe;rollback;

I believe this is already the recommended approach if you're concerned
about what DROP CASCADE will do.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: LIST OWNED BY...
Next
From: Thom Brown
Date:
Subject: Re: LIST OWNED BY...