2
.\" Title: DROP OPERATOR FAMILY
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.3beta1 Documentation
7
.\" Source: PostgreSQL 9.3beta1
10
.TH "DROP OPERATOR FAMILY" "7" "2013-05-06" "PostgreSQL 9.3beta1" "PostgreSQL 9.3beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * Define some portability stuff
13
.\" -----------------------------------------------------------------
14
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15
.\" http://bugs.debian.org/507673
16
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
17
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
20
.\" -----------------------------------------------------------------
21
.\" * set default formatting
22
.\" -----------------------------------------------------------------
23
.\" disable hyphenation
25
.\" disable justification (adjust text to left margin only)
27
.\" -----------------------------------------------------------------
28
.\" * MAIN CONTENT STARTS HERE *
29
.\" -----------------------------------------------------------------
31
DROP_OPERATOR_FAMILY \- remove an operator family
32
.\" DROP OPERATOR FAMILY
36
DROP OPERATOR FAMILY [ IF EXISTS ] \fIname\fR USING \fIindex_method\fR [ CASCADE | RESTRICT ]
41
\fBDROP OPERATOR FAMILY\fR
42
drops an existing operator family\&. To execute this command you must be the owner of the operator family\&.
45
\fBDROP OPERATOR FAMILY\fR
46
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
48
for the drop to complete\&.
53
Do not throw an error if the operator family does not exist\&. A notice is issued in this case\&.
58
The name (optionally schema\-qualified) of an existing operator family\&.
63
The name of the index access method the operator family is for\&.
68
Automatically drop objects that depend on the operator family\&.
73
Refuse to drop the operator family if any objects depend on it\&. This is the default\&.
77
Remove the B\-tree operator family
84
DROP OPERATOR FAMILY float_ops USING btree;
90
This command will not succeed if there are any existing indexes that use operator classes within the family\&. Add
92
to drop such indexes along with the operator family\&.
96
\fBDROP OPERATOR FAMILY\fR
97
statement in the SQL standard\&.
99
ALTER OPERATOR FAMILY (\fBALTER_OPERATOR_FAMILY\fR(7)), CREATE OPERATOR FAMILY (\fBCREATE_OPERATOR_FAMILY\fR(7)), ALTER OPERATOR CLASS (\fBALTER_OPERATOR_CLASS\fR(7)), CREATE OPERATOR CLASS (\fBCREATE_OPERATOR_CLASS\fR(7)), DROP OPERATOR CLASS (\fBDROP_OPERATOR_CLASS\fR(7))