diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-06-25 21:55:59 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-06-25 21:55:59 +0000 |
| commit | 0adfa2c39d567394f423c69bfaf467d0d00ee3df (patch) | |
| tree | 215559f976b4e28454fcf7abaa8c96c748ec7fef /doc/src/sgml/ref/alter_aggregate.sgml | |
| parent | 1621192b11369a7f0c47aaff1c8ec16bad29ab69 (diff) | |
| download | postgresql-0adfa2c39d567394f423c69bfaf467d0d00ee3df.tar.gz postgresql-0adfa2c39d567394f423c69bfaf467d0d00ee3df.zip | |
Support renaming of tablespaces, and changing the owners of
aggregates, conversions, functions, operators, operator classes,
schemas, types, and tablespaces. Fold the existing implementations
of alter domain owner and alter database owner in with these.
Christopher Kings-Lynne
Diffstat (limited to 'doc/src/sgml/ref/alter_aggregate.sgml')
| -rw-r--r-- | doc/src/sgml/ref/alter_aggregate.sgml | 24 |
1 files changed, 21 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/alter_aggregate.sgml b/doc/src/sgml/ref/alter_aggregate.sgml index 112242f1421..bfdb1761d5b 100644 --- a/doc/src/sgml/ref/alter_aggregate.sgml +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_aggregate.sgml,v 1.4 2003/11/29 19:51:38 pgsql Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_aggregate.sgml,v 1.5 2004/06/25 21:55:50 tgl Exp $ PostgreSQL documentation --> @@ -21,6 +21,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable> ) RENAME TO <replaceable>newname</replaceable> +ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable> ) OWNER TO <replaceable>newowner</replaceable> </synopsis> </refsynopsisdiv> @@ -29,8 +30,7 @@ ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable <para> <command>ALTER AGGREGATE</command> changes the definition of an - aggregate function. The only currently available functionality is to - rename the aggregate function. + aggregate function. </para> </refsect1> @@ -65,6 +65,16 @@ ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable </para> </listitem> </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">newowner</replaceable></term> + <listitem> + <para> + The new owner of the aggregate function. + You must be a superuser to change an aggregate's owner. + </para> + </listitem> + </varlistentry> </variablelist> </refsect1> @@ -78,6 +88,14 @@ ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable ALTER AGGREGATE myavg(integer) RENAME TO my_average; </programlisting> </para> + + <para> + To change the owner of the aggregate function <literal>myavg</literal> for type + <type>integer</type> to <literal>joe</literal>: +<programlisting> +ALTER AGGREGATE myavg(integer) OWNER TO joe; +</programlisting> + </para> </refsect1> <refsect1> |