DROP OPERATOR FAMILY — remove an operator family.
Synopsis
DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]Description
DROP OPERATOR FAMILY removes an existing operator family. To run this command, you must be the owner of the operator family.
Dropping an operator family also drops any operator classes contained in the family, but does not drop the operators or functions referenced by the family. If any indexes depend on operator classes within the family, specify CASCADE to complete the drop.
Parameters
| Parameter | Description |
|---|---|
IF EXISTS | Do not throw an error if the operator family does not exist. A notice is issued instead. |
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. |
RESTRICT | Refuse to drop the operator family if any objects depend on it. This is the default. |
Examples
Remove the B-tree operator family float_ops:
DROP OPERATOR FAMILY float_ops USING btree;This command fails if any existing indexes use operator classes within the family. Add CASCADE to drop those indexes along with the operator family:
DROP OPERATOR FAMILY float_ops USING btree CASCADE;