diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-02-10 17:36:44 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-02-10 17:37:22 -0500 |
| commit | 01467d3e4f51fe304c0160c9895484ad696d1e87 (patch) | |
| tree | 6ce04b83da1f5c472281b3970eab67e2b8fc0d6a /doc/src | |
| parent | 289d7306555b2446d145c7e098c91b6ca20bd54c (diff) | |
| download | postgresql-01467d3e4f51fe304c0160c9895484ad696d1e87.tar.gz postgresql-01467d3e4f51fe304c0160c9895484ad696d1e87.zip | |
Extend "ALTER EXTENSION ADD object" to permit "DROP object" as well.
Per discussion, this is something we should have sooner rather than later,
and it doesn't take much additional code to support it.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_extension.sgml | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_extension.sgml b/doc/src/sgml/ref/alter_extension.sgml index 6613418fd23..e9eb1aafbb6 100644 --- a/doc/src/sgml/ref/alter_extension.sgml +++ b/doc/src/sgml/ref/alter_extension.sgml @@ -25,6 +25,7 @@ PostgreSQL documentation <synopsis> ALTER EXTENSION <replaceable class="PARAMETER">extension_name</replaceable> SET SCHEMA <replaceable class="PARAMETER">new_schema</replaceable> ALTER EXTENSION <replaceable class="PARAMETER">extension_name</replaceable> ADD <replaceable class="PARAMETER">member_object</replaceable> +ALTER EXTENSION <replaceable class="PARAMETER">extension_name</replaceable> DROP <replaceable class="PARAMETER">member_object</replaceable> <phrase>where <replaceable class="PARAMETER">member_object</replaceable> is:</phrase> @@ -82,6 +83,17 @@ ALTER EXTENSION <replaceable class="PARAMETER">extension_name</replaceable> ADD </para> </listitem> </varlistentry> + + <varlistentry> + <term><literal>DROP <replaceable class="PARAMETER">member_object</replaceable></literal></term> + <listitem> + <para> + This form removes a member object from the extension. This is mainly + useful in extension upgrade scripts. The object is not dropped, only + disassociated from the extension. + </para> + </listitem> + </varlistentry> </variablelist> See <xref linkend="extend-extensions"> for more information about these @@ -123,7 +135,8 @@ ALTER EXTENSION <replaceable class="PARAMETER">extension_name</replaceable> ADD <term><replaceable class="parameter">operator_name</replaceable></term> <listitem> <para> - The name of an object to be added to the extension. Names of tables, + The name of an object to be added to or removed from the extension. + Names of tables, aggregates, domains, foreign tables, functions, operators, operator classes, operator families, sequences, text search objects, types, and views can be schema-qualified. |