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.12 2001/10/26 21:17:03 tgl Exp $
   3 Postgres 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  <refnamediv>
  12   <refname>
  13    DROP LANGUAGE
  14   </refname>
  15   <refpurpose>
  16    remove a user-defined procedural language
  17   </refpurpose>
  18  </refnamediv>
  19  <refsynopsisdiv>
  20   <refsynopsisdivinfo>
  21    <date>1999-07-20</date>
  22   </refsynopsisdivinfo>
  23   <synopsis>
  24 DROP [ PROCEDURAL ] LANGUAGE <replaceable class="PARAMETER">name</replaceable>
  25   </synopsis>
  26
  27   <refsect2 id="R2-SQL-DROPLANGUAGE-1">
  28    <refsect2info>
  29     <date>1998-04-15</date>
  30    </refsect2info>
  31    <title>
  32     Inputs
  33    </title>
  34    <para>
  35
  36     <variablelist>
  37      <varlistentry>
  38       <term><replaceable class="PARAMETER">name</replaceable></term>
  39       <listitem>
  40        <para>
  41         The name of an existing procedural language.  For backward
  42         compatibility, the name may be enclosed by single quotes.
  43        </para>
  44       </listitem>
  45      </varlistentry>
  46     </variablelist>
  47    </para>
  48   </refsect2>
  49
  50   <refsect2 id="R2-SQL-DROPLANGUAGE-2">
  51    <refsect2info>
  52     <date>1998-04-15</date>
  53    </refsect2info>
  54    <title>
  55     Outputs
  56    </title>
  57    <para>
  58     <variablelist>
  59      <varlistentry>
  60       <term><computeroutput>
  61 DROP
  62        </computeroutput></term>
  63       <listitem>
  64        <para>
  65         This message is returned if the language is successfully dropped.
  66        </para>
  67       </listitem>
  68      </varlistentry>
  69      <varlistentry>
  70       <term><computeroutput>
  71 ERROR: Language "<replaceable class="parameter">name</replaceable>" doesn't exist
  72        </computeroutput></term>
  73       <listitem>
  74        <para>
  75         This message occurs if a language called
  76         <replaceable class="parameter">name</replaceable> is
  77         not found in the database.
  78        </para>
  79       </listitem>
  80      </varlistentry>
  81     </variablelist>
  82    </para>
  83   </refsect2>
  84  </refsynopsisdiv>
  85
  86  <refsect1 id="R1-SQL-DROPLANGUAGE-1">
  87   <refsect1info>
  88    <date>1998-04-15</date>
  89   </refsect1info>
  90   <title>
  91    Description
  92   </title>
  93   <para>
  94    <command>DROP PROCEDURAL LANGUAGE</command> will remove the definition
  95    of the previously registered procedural language called
  96    <replaceable class="parameter">name</replaceable>.
  97   </para>
  98
  99   <refsect2 id="R2-SQL-DROPLANGUAGE-3">
 100    <refsect2info>
 101     <date>1998-04-15</date>
 102    </refsect2info>
 103    <title>
 104     Notes
 105    </title>
 106    <para>
 107     The <command>DROP PROCEDURAL LANGUAGE</command> statement is
 108     a <productname>Postgres</productname> language extension.
 109    </para>
 110    <para>
 111     Refer to
 112     <xref linkend="sql-createlanguage" endterm="sql-createlanguage-title">
 113     for information on how to create procedural languages.
 114    </para>
 115
 116    <para>
 117     No checks are made if functions or trigger procedures registered
 118     in this language still exist. To re-enable them without having
 119     to drop and recreate all the functions, the pg_proc's prolang
 120     attribute of the functions must be adjusted to the new object
 121     ID of the recreated pg_language entry for the PL.
 122    </para>
 123   </refsect2>
 124  </refsect1>
 125
 126  <refsect1 id="R1-SQL-DROPLANGUAGE-2">
 127   <title>
 128    Usage
 129   </title>
 130   <para>
 131    This command removes the PL/Sample language:
 132
 133    <programlisting>
 134 DROP LANGUAGE plsample;
 135    </programlisting>
 136   </para>
 137  </refsect1>
 138
 139  <refsect1 id="R1-SQL-DROPLANGUAGE-3">
 140   <title>
 141    Compatibility
 142   </title>
 143
 144   <refsect2 id="R2-SQL-DROPLANGUAGE-5">
 145    <refsect2info>
 146     <date>1998-04-15</date>
 147    </refsect2info>
 148    <title>
 149     SQL92
 150    </title>
 151    <para>
 152     There is no <command>DROP PROCEDURAL LANGUAGE</command> in
 153     <acronym>SQL92</acronym>.
 154    </para>
 155   </refsect2>
 156  </refsect1>
 157 </refentry>
 158
 159 <!-- Keep this comment at the end of the file
 160 Local variables:
 161 mode: sgml
 162 sgml-omittag:nil
 163 sgml-shorttag:t
 164 sgml-minimize-attributes:nil
 165 sgml-always-quote-attributes:t
 166 sgml-indent-step:1
 167 sgml-indent-data:t
 168 sgml-parent-document:nil
 169 sgml-default-dtd-file:"../reference.ced"
 170 sgml-exposed-tags:nil
 171 sgml-local-catalogs:"/usr/lib/sgml/catalog"
 172 sgml-local-ecat-files:nil
 173 End:
 174 -->