From a7b2f694e76859c9a6e61b75c12c73e9e93cfd38 Mon Sep 17 00:00:00 2001
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: Mon, 31 May 2010 18:47:35 +0000
Subject: [PATCH] Add note about database ownership to REASSIGN OWNED command
 documentation, per Josh Berkus.  Add ALTER DATABASE to the "see also"
 section, too.

---
 doc/src/sgml/ref/reassign_owned.sgml | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml
index 069b99491f..84d7a9796b 100644
--- a/doc/src/sgml/ref/reassign_owned.sgml
+++ b/doc/src/sgml/ref/reassign_owned.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/reassign_owned.sgml,v 1.6 2010/04/03 07:23:02 petere Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/reassign_owned.sgml,v 1.7 2010/05/31 18:47:35 alvherre Exp $
 PostgreSQL documentation
 -->
 
@@ -92,6 +92,12 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...]
    privileges.
   </para>
 
+  <para>
+   The <command>REASSIGN OWNED</command> command does not affect the
+   ownership of any databases owned by the role.  Use
+   <xref linkend="sql-alterdatabase"> to reassign that ownership.
+  </para>
+
  </refsect1>
 
  <refsect1>
@@ -109,6 +115,7 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...]
   <simplelist type="inline">
    <member><xref linkend="sql-drop-owned"></member>
    <member><xref linkend="sql-droprole"></member>
+   <member><xref linkend="sql-alterdatabase"></member>
   </simplelist>
  </refsect1>
 
-- 
2.40.0