From 01467d3e4f51fe304c0160c9895484ad696d1e87 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 10 Feb 2011 17:36:44 -0500 Subject: 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. --- doc/src/sgml/ref/alter_extension.sgml | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) (limited to 'doc/src') 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 ALTER EXTENSION extension_name SET SCHEMA new_schema ALTER EXTENSION extension_name ADD member_object +ALTER EXTENSION extension_name DROP member_object where member_object is: @@ -82,6 +83,17 @@ ALTER EXTENSION extension_name ADD + + + DROP member_object + + + 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. + + + See for more information about these @@ -123,7 +135,8 @@ ALTER EXTENSION extension_name ADD operator_name - 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. -- cgit v1.2.3