Note addition to REASSIGN OWNED

Excerpts from Josh Berkus's message of mié may 05 23:24:44 -0400 2010:

Need this sentence added in the Notes section of sql-reassign-owned:

REASSIGN OWNED will not reassign the ownership of any databases owned by
the role. These still need to be changed using ALTER DATABASE.

I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
OWNED. Do we really need to fix the docs, or should we fix the code?
--

Alvaro Herrera wrote:

Excerpts from Josh Berkus's message of mi�� may 05 23:24:44 -0400 2010:

Need this sentence added in the Notes section of sql-reassign-owned:

REASSIGN OWNED will not reassign the ownership of any databases owned by
the role. These still need to be changed using ALTER DATABASE.

I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
OWNED. Do we really need to fix the docs, or should we fix the code?

Where are we on this?

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ None of us is going to be here forever. +

Excerpts from Bruce Momjian's message of lun may 31 13:58:36 -0400 2010:

Alvaro Herrera wrote:

Excerpts from Josh Berkus's message of mi\xc3\xa9 may 05 23:24:44 -0400 2010:

Need this sentence added in the Notes section of sql-reassign-owned:

REASSIGN OWNED will not reassign the ownership of any databases owned by
the role. These still need to be changed using ALTER DATABASE.

I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
OWNED. Do we really need to fix the docs, or should we fix the code?

Where are we on this?

I just patched the docs, slightly rewording Josh's suggestion.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support