drop_language.sgml
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:4k
源码类别:

数据库系统

开发平台:

Unix_Linux

  1. <refentry id="SQL-DROPLANGUAGE">
  2.  <refmeta>
  3.   <refentrytitle>
  4.    DROP LANGUAGE
  5.   </refentrytitle>
  6.   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  7.  </refmeta>
  8.  <refnamediv>
  9.   <refname>
  10.    DROP LANGUAGE
  11.   </refname>
  12.   <refpurpose>
  13.    Removes a user-defined procedural language
  14.   </refpurpose>
  15.  </refnamediv>
  16.  <refsynopsisdiv>
  17.   <refsynopsisdivinfo>
  18.    <date>1998-04-15</date>
  19.   </refsynopsisdivinfo>
  20.   <synopsis>
  21. DROP PROCEDURAL LANGUAGE '<replaceable class="PARAMETER">name</replaceable>'
  22.   </synopsis>
  23.   
  24.   <refsect2 id="R2-SQL-DROPLANGUAGE-1">
  25.    <refsect2info>
  26.     <date>1998-04-15</date>
  27.    </refsect2info>
  28.    <title>
  29.     Inputs
  30.    </title>
  31.    <para>
  32.     <variablelist>
  33.      <varlistentry>
  34.       <term><replaceable class="PARAMETER">name</replaceable></term>
  35.       <listitem>
  36.        <para>
  37. The name of an existing procedural language.
  38.        </para>
  39.       </listitem>
  40.      </varlistentry>
  41.     </variablelist>
  42.    </para>
  43.   </refsect2>
  44.   
  45.   <refsect2 id="R2-SQL-DROPLANGUAGE-2">
  46.    <refsect2info>
  47.     <date>1998-04-15</date>
  48.    </refsect2info>
  49.    <title>
  50.     Outputs
  51.    </title>
  52.    <para>
  53.     <variablelist>
  54.      <varlistentry>
  55.       <term><computeroutput>
  56. DROP
  57.        </computeroutput></term>
  58.       <listitem>
  59.        <para>
  60. This message is returned if the language is successfully dropped.
  61.        </para>
  62.       </listitem>
  63.      </varlistentry>
  64.      <varlistentry>
  65.       <term><computeroutput>
  66. ERROR: Language "<replaceable class="parameter">name</replaceable>" doesn't exist
  67.        </computeroutput></term>
  68.       <listitem>
  69.        <para>
  70. This message occurs if a language called
  71. <replaceable class="parameter">name</replaceable> is
  72. not found in the database.
  73.        </para>
  74.       </listitem>
  75.      </varlistentry>
  76.     </variablelist>
  77.    </para>
  78.   </refsect2>
  79.  </refsynopsisdiv>
  80.  
  81.  <refsect1 id="R1-SQL-DROPLANGUAGE-1">
  82.   <refsect1info>
  83.    <date>1998-04-15</date>
  84.   </refsect1info>
  85.   <title>
  86.    Description
  87.   </title>
  88.   <para>
  89.    <command>DROP PROCEDURAL LANGUAGE</command> will remove the definition
  90.    of the previously registered procedural language called
  91.    <replaceable class="parameter">name</replaceable>.
  92.   </para>
  93.   
  94.   <refsect2 id="R2-SQL-DROPLANGUAGE-3">
  95.    <refsect2info>
  96.     <date>1998-04-15</date>
  97.    </refsect2info>
  98.    <title>
  99.     Notes
  100.    </title>
  101.    <para>
  102.     The <command>DROP PROCEDURAL LANGUAGE</command> statement is
  103.     a <productname>Postgres</productname> language extension.
  104.    </para>
  105.    <para>
  106.     Refer to <command>CREATE PROCEDURAL LANGUAGE</command>
  107.     for information on how to create procedural languages.
  108.    </para>
  109.   </refsect2>
  110.   
  111.   <refsect2 id="R2-SQL-DROPLANGUAGE-4">
  112.    <refsect2info>
  113.     <date>1998-04-15</date>
  114.    </refsect2info>
  115.    <title>
  116.     Bugs
  117.    </title>
  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.    <programlisting>
  135. DROP PROCEDURAL LANGUAGE 'plsample';
  136.    </programlisting>
  137.   </para>
  138.  </refsect1>
  139.  
  140.  <refsect1 id="R1-SQL-DROPLANGUAGE-3">
  141.   <title>
  142.    Compatibility
  143.   </title>
  144.   <para>
  145.   </para>
  146.   
  147.   <refsect2 id="R2-SQL-DROPLANGUAGE-5">
  148.    <refsect2info>
  149.     <date>1998-04-15</date>
  150.    </refsect2info>
  151.    <title>
  152.     SQL92
  153.    </title>
  154.    <para>
  155.     There is no <command>DROP PROCEDURAL LANGUAGE</command> in 
  156.     <acronym>SQL92</acronym>.
  157.    </para>
  158.   </refsect2>
  159.  </refsect1>
  160. </refentry>
  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. -->