Stephen Frost wrote:
> The non-documentation question is around DROP OWNED. We need to either
> have policies dropped by DROP OWNED (well, roles removed, unless it's
> the last one, in which case the policy should be dropped), or update the
> documentation to reflect that they don't. I had been thinking we'd
> fix DROP OWNED to deal with the policies, but if folks feel it's too
> late for that kind of a change, then we can simply document it. I don't
> believe that's unreasonable for a new feature and we can work to get it
> addressed in 9.6.
DROP OWNED is documented as a mechanism to help you drop the role, so
it should do whatever is needed for that. I don't think documenting the
fact that it leaves the user as part of policies is good enough.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services