From cfbfdc557d166ec559668d18d9769544f3c4fbbc Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Wed, 26 May 2004 13:57:04 +0000
Subject: This patch implement the TODO [ALTER DATABASE foo OWNER TO bar]. It
 was necessary to touch in grammar and create a new node to make home to the
 new syntax. The command is also supported in E CPG. Doc updates are attached
 too. Only superusers can change the owner of the database. New owners don't
 need any aditional privileges.

Euler Taveira de Oliveira
---
 doc/src/sgml/ref/alter_database.sgml | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml
index aa34fac9f05..86093712f88 100644
--- a/doc/src/sgml/ref/alter_database.sgml
+++ b/doc/src/sgml/ref/alter_database.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.11 2003/11/29 19:51:38 pgsql Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.12 2004/05/26 13:56:42 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -23,6 +23,8 @@ PostgreSQL documentation
 ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> SET <replaceable>parameter</replaceable> { TO | = } { <replaceable>value</replaceable> | DEFAULT }
 ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET <replaceable>parameter</replaceable>
 
+ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> OWNER TO <replaceable>new_owner</replaceable>
+
 ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>newname</replaceable>
 </synopsis>
  </refsynopsisdiv>
@@ -54,6 +56,11 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <repl
    be renamed.  (Connect to a different database if you need to do
    that.)
   </para>
+
+  <para>
+   The fourth form changes the owner of the database.  Only a superuser
+   can change the database's owner.
+  </para>
  </refsect1>
 
  <refsect1>
-- 
cgit v1.2.3