granicus.if.org Git - postgresql/blob - doc/src/sgml/ref/drop_language.sgml

   1 <!--
   2 $Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_language.sgml,v 1.20 2003/09/22 00:16:58 petere Exp $
   3 PostgreSQL documentation
   4 -->
   5
   6 <refentry id="SQL-DROPLANGUAGE">
   7  <refmeta>
   8   <refentrytitle id="SQL-DROPLANGUAGE-TITLE">DROP LANGUAGE</refentrytitle>
   9   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  10  </refmeta>
  11
  12  <refnamediv>
  13   <refname>DROP LANGUAGE</refname>
  14   <refpurpose>remove a procedural language</refpurpose>
  15  </refnamediv>
  16
  17  <indexterm zone="sql-droplanguage">
  18   <primary>DROP LANGUAGE</primary>
  19  </indexterm>
  20
  21  <refsynopsisdiv>
  22 <synopsis>
  23 DROP [ PROCEDURAL ] LANGUAGE <replaceable class="PARAMETER">name</replaceable> [ CASCADE | RESTRICT ]
  24 </synopsis>
  25  </refsynopsisdiv>
  26
  27  <refsect1>
  28   <title>Description</title>
  29
  30   <para>
  31    <command>DROP LANGUAGE</command> will remove the definition
  32    of the previously registered procedural language called
  33    <replaceable class="parameter">name</replaceable>.
  34   </para>
  35  </refsect1>
  36
  37  <refsect1>
  38   <title>Parameters</title>
  39
  40   <variablelist>
  41    <varlistentry>
  42     <term><replaceable class="PARAMETER">name</replaceable></term>
  43     <listitem>
  44      <para>
  45       The name of an existing procedural language.  For backward
  46       compatibility, the name may be enclosed by single quotes.
  47      </para>
  48     </listitem>
  49    </varlistentry>
  50
  51    <varlistentry>
  52     <term><literal>CASCADE</literal></term>
  53     <listitem>
  54      <para>
  55       Automatically drop objects that depend on the language (such as
  56       functions in the language).
  57      </para>
  58     </listitem>
  59    </varlistentry>
  60
  61    <varlistentry>
  62     <term><literal>RESTRICT</literal></term>
  63     <listitem>
  64      <para>
  65       Refuse to drop the language if any objects depend on it.  This
  66       is the default.
  67      </para>
  68     </listitem>
  69    </varlistentry>
  70   </variablelist>
  71  </refsect1>
  72
  73  <refsect1>
  74   <title>Examples</title>
  75
  76   <para>
  77    This command removes the procedural language
  78    <literal>plsample</literal>:
  79
  80 <programlisting>
  81 DROP LANGUAGE plsample;
  82 </programlisting>
  83   </para>
  84  </refsect1>
  85
  86  <refsect1>
  87   <title>Compatibility</title>
  88
  89   <para>
  90    There is no <command>DROP LANGUAGE</command> statement in the SQL
  91    standard.
  92   </para>
  93  </refsect1>
  94
  95  <refsect1>
  96   <title>See Also</title>
  97
  98   <simplelist type="inline">
  99    <member><xref linkend="sql-alterlanguage" endterm="sql-alterlanguage-title"></member>
 100    <member><xref linkend="sql-createlanguage" endterm="sql-createlanguage-title"></member>
 101    <member><xref linkend="app-droplang"></member>
 102   </simplelist>
 103  </refsect1>
 104
 105 </refentry>
 106
 107 <!-- Keep this comment at the end of the file
 108 Local variables:
 109 mode: sgml
 110 sgml-omittag:nil
 111 sgml-shorttag:t
 112 sgml-minimize-attributes:nil
 113 sgml-always-quote-attributes:t
 114 sgml-indent-step:1
 115 sgml-indent-data:t
 116 sgml-parent-document:nil
 117 sgml-default-dtd-file:"../reference.ced"
 118 sgml-exposed-tags:nil
 119 sgml-local-catalogs:"/usr/lib/sgml/catalog"
 120 sgml-local-ecat-files:nil
 121 End:
 122 -->