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

From Thom Brown
Subject LIST OWNED BY...
Date
Msg-id CAA-aLv6C-dttXgXkXFUCb2ni20TB8t918W5pgNFfvw4wGF69CQ@mail.gmail.com
Whole thread Raw
Responses Re: LIST OWNED BY...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi all,

If someone wants to drop objects owned by a particular role, they'll
use DROP OWNED BY role.  However, the implications of this statement
aren't easily known, and once you've run it, it's not communicated
which objects were dropped.

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?  Also when
DROP OWNED BY has been executed, shouldn't we get feedback about what
it did?  At the moment the only feedback provided is what objects the
statement cascaded to.

-- 
Thom


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: 16-bit page checksums for 9.2
Next
From: Tom Lane
Date:
Subject: Re: LIST OWNED BY...