Postgresql 中文操作指南
DROP OPERATOR FAMILY
DROP OPERATOR FAMILY — 删除一个运算符族
DROP OPERATOR FAMILY — remove an operator family
Description
DROP OPERATOR FAMILY 删除一个现有运算符族。要执行此命令，您必须是运算符族的所有者。
DROP OPERATOR FAMILY drops an existing operator family. To execute this command you must be the owner of the operator family.
DROP OPERATOR FAMILY 包含删除族中包含的任何运算符类，但它不会删除族引用的任何运算符或函数。如果存在取决于族中运算符类的任何索引，您需要指定 CASCADE 以完成删除。
DROP OPERATOR FAMILY includes dropping any operator classes contained in the family, but it does not drop any of the operators or functions referenced by the family. If there are any indexes depending on operator classes within the family, you will need to specify CASCADE for the drop to complete.
Parameters
-
IF EXISTS
-
Do not throw an error if the operator family does not exist. A notice is issued in this case.
-
-
name
-
The name (optionally schema-qualified) of an existing operator family.
-
-
index_method
-
The name of the index access method the operator family is for.
-
-
CASCADE
-
Automatically drop objects that depend on the operator family, and in turn all objects that depend on those objects (see Section 5.14).
-
-
RESTRICT
-
Refuse to drop the operator family if any objects depend on it. This is the default.
-
Examples
删除 B 树运算符系列 float_ops ：
Remove the B-tree operator family float_ops:
DROP OPERATOR FAMILY float_ops USING btree;如果存在任何使用该系列中运算符类的现有索引，则此命令将不会成功。将 CASCADE 添加到删除操作中，以便同时删除此类索引和运算符系列。
This command will not succeed if there are any existing indexes that use operator classes within the family. Add CASCADE to drop such indexes along with the operator family.