diff options
author | Peter Eisentraut <peter_e@gmx.net> | 2011-12-09 20:42:30 +0200 |
---|---|---|
committer | Peter Eisentraut <peter_e@gmx.net> | 2011-12-09 20:42:30 +0200 |
commit | 5bcf8ede45c780e4ac394397bd0413118f3a162f (patch) | |
tree | 69336b13a01a9e2bdc68e3145676d39bb511a65b /doc/src | |
parent | 9f0d2bdc88630781485a17178e2b50e49ce70040 (diff) | |
download | postgresql-5bcf8ede45c780e4ac394397bd0413118f3a162f.tar.gz postgresql-5bcf8ede45c780e4ac394397bd0413118f3a162f.zip |
Add ALTER FOREIGN DATA WRAPPER / RENAME and ALTER SERVER / RENAME
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/alter_foreign_data_wrapper.sgml | 22 | ||||
-rw-r--r-- | doc/src/sgml/ref/alter_server.sgml | 21 |
2 files changed, 42 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml index 59cf9c65e77..7376804403d 100644 --- a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml @@ -26,6 +26,7 @@ ALTER FOREIGN DATA WRAPPER <replaceable class="parameter">name</replaceable> [ VALIDATOR <replaceable class="parameter">validator_function</replaceable> | NO VALIDATOR ] [ OPTIONS ( [ ADD | SET | DROP ] <replaceable class="PARAMETER">option</replaceable> ['<replaceable class="PARAMETER">value</replaceable>'] [, ... ]) ] ALTER FOREIGN DATA WRAPPER <replaceable class="parameter">name</replaceable> OWNER TO <replaceable>new_owner</replaceable> +ALTER FOREIGN DATA WRAPPER <replaceable class="parameter">name</replaceable> RENAME TO <replaceable>new_name</replaceable> </synopsis> </refsynopsisdiv> @@ -122,6 +123,24 @@ ALTER FOREIGN DATA WRAPPER <replaceable class="parameter">name</replaceable> OWN </para> </listitem> </varlistentry> + + <varlistentry> + <term><replaceable class="PARAMETER">new_owner</replaceable></term> + <listitem> + <para> + The user name of the new owner of the foreign-data wrapper. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">new_name</replaceable></term> + <listitem> + <para> + The new name for the foreign-data wrapper. + </para> + </listitem> + </varlistentry> </variablelist> </refsect1> @@ -150,7 +169,8 @@ ALTER FOREIGN DATA WRAPPER dbi VALIDATOR bob.myvalidator; <para> <command>ALTER FOREIGN DATA WRAPPER</command> conforms to ISO/IEC 9075-9 (SQL/MED), except that the <literal>HANDLER</literal>, - <literal>VALIDATOR</> and <literal>OWNER TO</> clauses are extensions. + <literal>VALIDATOR</>, <literal>OWNER TO</>, and <literal>RENAME</literal> + clauses are extensions. </para> </refsect1> diff --git a/doc/src/sgml/ref/alter_server.sgml b/doc/src/sgml/ref/alter_server.sgml index c27b4c06a1c..248efd91630 100644 --- a/doc/src/sgml/ref/alter_server.sgml +++ b/doc/src/sgml/ref/alter_server.sgml @@ -24,6 +24,7 @@ PostgreSQL documentation ALTER SERVER <replaceable class="parameter">server_name</replaceable> [ VERSION '<replaceable class="parameter">new_version</replaceable>' ] [ OPTIONS ( [ ADD | SET | DROP ] <replaceable class="PARAMETER">option</replaceable> ['<replaceable class="PARAMETER">value</replaceable>'] [, ... ] ) ] ALTER SERVER <replaceable class="PARAMETER">server_name</replaceable> OWNER TO <replaceable>new_owner</replaceable> +ALTER SERVER <replaceable class="PARAMETER">server_name</replaceable> RENAME TO <replaceable>new_name</replaceable> </synopsis> </refsynopsisdiv> @@ -82,6 +83,24 @@ ALTER SERVER <replaceable class="PARAMETER">server_name</replaceable> OWNER TO < </para> </listitem> </varlistentry> + + <varlistentry> + <term><replaceable class="PARAMETER">new_owner</replaceable></term> + <listitem> + <para> + The user name of the new owner of the foreign server. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">new_name</replaceable></term> + <listitem> + <para> + The new name for the foreign server. + </para> + </listitem> + </varlistentry> </variablelist> </refsect1> @@ -108,6 +127,8 @@ ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz'); <para> <command>ALTER SERVER</command> conforms to ISO/IEC 9075-9 (SQL/MED). + The <literal>OWNER TO</literal> and <literal>RENAME</literal> forms are + PostgreSQL extensions. </para> </refsect1> |