Skip to content

Commit e287fb2

Browse files
adunstanadunstan
committed
docs for DROP ... IF EXISTS for the following cases: language, tablespace, trigger, rule, opclass, function, aggregate. operator, and cast.
1 parent bac6570 commit e287fb2

9 files changed

+117
-19
lines changed

‎doc/src/sgml/ref/drop_aggregate.sgml

+13-2
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.27 2003/11/29 19:51:38 pgsql Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.28 2006/06/16 22:27:55 adunstan Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
DROP AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( <replaceable class="PARAMETER">type</replaceable> ) [ CASCADE | RESTRICT ]
23+
DROP AGGREGATE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> ( <replaceable class="PARAMETER">type</replaceable> ) [ CASCADE | RESTRICT ]
2424
</synopsis>
2525
</refsynopsisdiv>
2626

@@ -38,6 +38,17 @@ DROP AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( <replaceable
3838
<title>Parameters</title>
3939

4040
<variablelist>
41+
42+
<varlistentry>
43+
<term><literal>IF EXISTS</literal></term>
44+
<listitem>
45+
<para>
46+
Do not throw an error if the aggregate does not exist. A notice is issued
47+
in this case.
48+
</para>
49+
</listitem>
50+
</varlistentry>
51+
4152
<varlistentry>
4253
<term><replaceable class="parameter">name</replaceable></term>
4354
<listitem>

‎doc/src/sgml/ref/drop_cast.sgml

+13-2
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/drop_cast.sgml,v 1.6 2003/11/29 19:51:38 pgsql Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/drop_cast.sgml,v 1.7 2006/06/16 22:27:55 adunstan Exp $ -->
22

33
<refentry id="SQL-DROPCAST">
44
<refmeta>
@@ -17,7 +17,7 @@
1717

1818
<refsynopsisdiv>
1919
<synopsis>
20-
DROP CAST (<replaceable>sourcetype</replaceable> AS <replaceable>targettype</replaceable>) [ CASCADE | RESTRICT ]
20+
DROP CAST [ IF EXISTS ] (<replaceable>sourcetype</replaceable> AS <replaceable>targettype</replaceable>) [ CASCADE | RESTRICT ]
2121
</synopsis>
2222
</refsynopsisdiv>
2323

@@ -39,6 +39,17 @@ DROP CAST (<replaceable>sourcetype</replaceable> AS <replaceable>targettype</rep
3939
<title>Parameters</title>
4040

4141
<variablelist>
42+
43+
<varlistentry>
44+
<term><literal>IF EXISTS</literal></term>
45+
<listitem>
46+
<para>
47+
Do not throw an error if the cast does not exist. A notice is issued
48+
in this case.
49+
</para>
50+
</listitem>
51+
</varlistentry>
52+
4253
<varlistentry>
4354
<term><replaceable>sourcetype</replaceable></term>
4455

‎doc/src/sgml/ref/drop_function.sgml

+13-3
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_function.sgml,v 1.30 2005/05/26 20:05:03 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_function.sgml,v 1.31 2006/06/16 22:27:55 adunstan Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
DROP FUNCTION <replaceable class="parameter">name</replaceable> ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] )
23+
DROP FUNCTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable> ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] )
2424
[ CASCADE | RESTRICT ]
2525
</synopsis>
2626
</refsynopsisdiv>
@@ -41,7 +41,17 @@ DROP FUNCTION <replaceable class="parameter">name</replaceable> ( [ [ <replaceab
4141
<title>Parameters</title>
4242

4343
<variablelist>
44-
<varlistentry>
44+
<varlistentry>
45+
<term><literal>IF EXISTS</literal></term>
46+
<listitem>
47+
<para>
48+
Do not throw an error if the function does not exist. A notice is issued
49+
in this case.
50+
</para>
51+
</listitem>
52+
</varlistentry>
53+
54+
<varlistentry>
4555
<term><replaceable class="parameter">name</replaceable></term>
4656
<listitem>
4757
<para>

‎doc/src/sgml/ref/drop_language.sgml

+13-2
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_language.sgml,v 1.21 2003/11/29 19:51:38 pgsql Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_language.sgml,v 1.22 2006/06/16 22:27:55 adunstan Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
DROP [ PROCEDURAL ] LANGUAGE <replaceable class="PARAMETER">name</replaceable> [ CASCADE | RESTRICT ]
23+
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [ CASCADE | RESTRICT ]
2424
</synopsis>
2525
</refsynopsisdiv>
2626

@@ -38,6 +38,17 @@ DROP [ PROCEDURAL ] LANGUAGE <replaceable class="PARAMETER">name</replaceable> [
3838
<title>Parameters</title>
3939

4040
<variablelist>
41+
42+
<varlistentry>
43+
<term><literal>IF EXISTS</literal></term>
44+
<listitem>
45+
<para>
46+
Do not throw an error if the function does not exist. A notice is issued
47+
in this case.
48+
</para>
49+
</listitem>
50+
</varlistentry>
51+
4152
<varlistentry>
4253
<term><replaceable class="PARAMETER">name</replaceable></term>
4354
<listitem>

‎doc/src/sgml/ref/drop_opclass.sgml

+13-2
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_opclass.sgml,v 1.8 2003/11/29 19:51:38 pgsql Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_opclass.sgml,v 1.9 2006/06/16 22:27:55 adunstan Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
DROP OPERATOR CLASS <replaceable class="PARAMETER">name</replaceable> USING <replaceable class="PARAMETER">index_method</replaceable> [ CASCADE | RESTRICT ]
23+
DROP OPERATOR CLASS [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> USING <replaceable class="PARAMETER">index_method</replaceable> [ CASCADE | RESTRICT ]
2424
</synopsis>
2525
</refsynopsisdiv>
2626

@@ -37,6 +37,17 @@ DROP OPERATOR CLASS <replaceable class="PARAMETER">name</replaceable> USING <rep
3737
<title>Parameters</title>
3838

3939
<variablelist>
40+
41+
<varlistentry>
42+
<term><literal>IF EXISTS</literal></term>
43+
<listitem>
44+
<para>
45+
Do not throw an error if the operator class does not exist. A notice is issued
46+
in this case.
47+
</para>
48+
</listitem>
49+
</varlistentry>
50+
4051
<varlistentry>
4152
<term><replaceable class="parameter">name</replaceable></term>
4253
<listitem>

‎doc/src/sgml/ref/drop_operator.sgml

+13-2
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_operator.sgml,v 1.25 2004/06/25 21:55:50 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_operator.sgml,v 1.26 2006/06/16 22:27:55 adunstan Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
DROP OPERATOR <replaceable class="PARAMETER">name</replaceable> ( { <replaceable class="PARAMETER">lefttype</replaceable> | NONE } , { <replaceable class="PARAMETER">righttype</replaceable> | NONE } ) [ CASCADE | RESTRICT ]
23+
DROP OPERATOR [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> ( { <replaceable class="PARAMETER">lefttype</replaceable> | NONE } , { <replaceable class="PARAMETER">righttype</replaceable> | NONE } ) [ CASCADE | RESTRICT ]
2424
</synopsis>
2525
</refsynopsisdiv>
2626

@@ -38,6 +38,17 @@ DROP OPERATOR <replaceable class="PARAMETER">name</replaceable> ( { <replaceable
3838
<title>Parameters</title>
3939

4040
<variablelist>
41+
42+
<varlistentry>
43+
<term><literal>IF EXISTS</literal></term>
44+
<listitem>
45+
<para>
46+
Do not throw an error if the operator does not exist. A notice is issued
47+
in this case.
48+
</para>
49+
</listitem>
50+
</varlistentry>
51+
4152
<varlistentry>
4253
<term><replaceable class="parameter">name</replaceable></term>
4354
<listitem>

‎doc/src/sgml/ref/drop_rule.sgml

+13-2
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_rule.sgml,v 1.20 2003/11/29 19:51:38 pgsql Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_rule.sgml,v 1.21 2006/06/16 22:27:55 adunstan Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
DROP RULE <replaceable class="PARAMETER">name</replaceable> ON <replaceable class="PARAMETER">relation</replaceable> [ CASCADE | RESTRICT ]
23+
DROP RULE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> ON <replaceable class="PARAMETER">relation</replaceable> [ CASCADE | RESTRICT ]
2424
</synopsis>
2525
</refsynopsisdiv>
2626

@@ -36,6 +36,17 @@ DROP RULE <replaceable class="PARAMETER">name</replaceable> ON <replaceable clas
3636
<title>Parameters</title>
3737

3838
<variablelist>
39+
40+
<varlistentry>
41+
<term><literal>IF EXISTS</literal></term>
42+
<listitem>
43+
<para>
44+
Do not throw an error if the rule does not exist. A notice is issued
45+
in this case.
46+
</para>
47+
</listitem>
48+
</varlistentry>
49+
3950
<varlistentry>
4051
<term><replaceable class="parameter">name</replaceable></term>
4152
<listitem>

‎doc/src/sgml/ref/drop_tablespace.sgml

+13-2
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_tablespace.sgml,v 1.2 2004/06/25 21:55:50 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_tablespace.sgml,v 1.3 2006/06/16 22:27:55 adunstan Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
DROP TABLESPACE <replaceable class="PARAMETER">tablespacename</replaceable>
23+
DROP TABLESPACE [ IF EXISTS ] <replaceable class="PARAMETER">tablespacename</replaceable>
2424
</synopsis>
2525
</refsynopsisdiv>
2626

@@ -44,6 +44,17 @@ DROP TABLESPACE <replaceable class="PARAMETER">tablespacename</replaceable>
4444
<title>Parameters</title>
4545

4646
<variablelist>
47+
48+
<varlistentry>
49+
<term><literal>IF EXISTS</literal></term>
50+
<listitem>
51+
<para>
52+
Do not throw an error if the tablespace does not exist. A notice is issued
53+
in this case.
54+
</para>
55+
</listitem>
56+
</varlistentry>
57+
4758
<varlistentry>
4859
<term><replaceable class="PARAMETER">tablespacename</replaceable></term>
4960
<listitem>

‎doc/src/sgml/ref/drop_trigger.sgml

+13-2
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_trigger.sgml,v 1.19 2004/09/20 00:04:19 neilc Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_trigger.sgml,v 1.20 2006/06/16 22:27:55 adunstan Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
DROP TRIGGER <replaceable class="PARAMETER">name</replaceable> ON <replaceable class="PARAMETER">table</replaceable> [ CASCADE | RESTRICT ]
23+
DROP TRIGGER [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> ON <replaceable class="PARAMETER">table</replaceable> [ CASCADE | RESTRICT ]
2424
</synopsis>
2525
</refsynopsisdiv>
2626

@@ -38,6 +38,17 @@ DROP TRIGGER <replaceable class="PARAMETER">name</replaceable> ON <replaceable c
3838
<title>Parameters</title>
3939

4040
<variablelist>
41+
42+
<varlistentry>
43+
<term><literal>IF EXISTS</literal></term>
44+
<listitem>
45+
<para>
46+
Do not throw an error if the trigger does not exist. A notice is issued
47+
in this case.
48+
</para>
49+
</listitem>
50+
</varlistentry>
51+
4152
<varlistentry>
4253
<term><replaceable class="PARAMETER">name</replaceable></term>
4354
<listitem>

0 commit comments

Comments
 (0)