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