- <refentry id="SQL-DROPLANGUAGE">
- <refmeta>
- <refentrytitle>
- DROP LANGUAGE
- </refentrytitle>
- <refmiscinfo>SQL - Language Statements</refmiscinfo>
- </refmeta>
- <refnamediv>
- <refname>
- DROP LANGUAGE
- </refname>
- <refpurpose>
- Removes a user-defined procedural language
- </refpurpose>
- </refnamediv>
- <refsynopsisdiv>
- <refsynopsisdivinfo>
- <date>1998-04-15</date>
- </refsynopsisdivinfo>
- <synopsis>
- DROP PROCEDURAL LANGUAGE '<replaceable class="PARAMETER">name</replaceable>'
- </synopsis>
- <refsect2 id="R2-SQL-DROPLANGUAGE-1">
- <refsect2info>
- <date>1998-04-15</date>
- </refsect2info>
- <title>
- Inputs
- </title>
- <para>
- <variablelist>
- <varlistentry>
- <term><replaceable class="PARAMETER">name</replaceable></term>
- <listitem>
- <para>
- The name of an existing procedural language.
- </para>
- </listitem>
- </varlistentry>
- </variablelist>
- </para>
- </refsect2>
- <refsect2 id="R2-SQL-DROPLANGUAGE-2">
- <refsect2info>
- <date>1998-04-15</date>
- </refsect2info>
- <title>
- Outputs
- </title>
- <para>
- <variablelist>
- <varlistentry>
- <term><computeroutput>
- DROP
- </computeroutput></term>
- <listitem>
- <para>
- This message is returned if the language is successfully dropped.
- </para>
- </listitem>
- </varlistentry>
- <varlistentry>
- <term><computeroutput>
- ERROR: Language "<replaceable class="parameter">name</replaceable>" doesn't exist
- </computeroutput></term>
- <listitem>
- <para>
- This message occurs if a language called
- <replaceable class="parameter">name</replaceable> is
- not found in the database.
- </para>
- </listitem>
- </varlistentry>
- </variablelist>
- </para>
- </refsect2>
- </refsynopsisdiv>
- <refsect1 id="R1-SQL-DROPLANGUAGE-1">
- <refsect1info>
- <date>1998-04-15</date>
- </refsect1info>
- <title>
- Description
- </title>
- <para>
- <command>DROP PROCEDURAL LANGUAGE</command> will remove the definition
- of the previously registered procedural language called
- <replaceable class="parameter">name</replaceable>.
- </para>
- <refsect2 id="R2-SQL-DROPLANGUAGE-3">
- <refsect2info>
- <date>1998-04-15</date>
- </refsect2info>
- <title>
- Notes
- </title>
- <para>
- The <command>DROP PROCEDURAL LANGUAGE</command> statement is
- a <productname>Postgres</productname> language extension.
- </para>
- <para>
- Refer to <command>CREATE PROCEDURAL LANGUAGE</command>
- for information on how to create procedural languages.
- </para>
- </refsect2>
- <refsect2 id="R2-SQL-DROPLANGUAGE-4">
- <refsect2info>
- <date>1998-04-15</date>
- </refsect2info>
- <title>
- Bugs
- </title>
- <para>
- No checks are made if functions or trigger procedures registered
- in this language still exist. To re-enable them without having
- to drop and recreate all the functions, the pg_proc's prolang
- attribute of the functions must be adjusted to the new object
- ID of the recreated pg_language entry for the PL.
- </para>
- </refsect2>
- </refsect1>
- <refsect1 id="R1-SQL-DROPLANGUAGE-2">
- <title>
- Usage
- </title>
- <para>
- This command removes the PL/Sample language:
- <programlisting>
- DROP PROCEDURAL LANGUAGE 'plsample';
- </programlisting>
- </para>
- </refsect1>
- <refsect1 id="R1-SQL-DROPLANGUAGE-3">
- <title>
- Compatibility
- </title>
- <para>
- </para>
- <refsect2 id="R2-SQL-DROPLANGUAGE-5">
- <refsect2info>
- <date>1998-04-15</date>
- </refsect2info>
- <title>
- SQL92
- </title>
- <para>
- There is no <command>DROP PROCEDURAL LANGUAGE</command> in
- <acronym>SQL92</acronym>.
- </para>
- </refsect2>
- </refsect1>
- </refentry>
- <!-- Keep this comment at the end of the file
- Local variables:
- mode: sgml
- sgml-omittag:nil
- sgml-shorttag:t
- sgml-minimize-attributes:nil
- sgml-always-quote-attributes:t
- sgml-indent-step:1
- sgml-indent-data:t
- sgml-parent-document:nil
- sgml-default-dtd-file:"../reference.ced"
- sgml-exposed-tags:nil
- sgml-local-catalogs:"/usr/lib/sgml/catalog"
- sgml-local-ecat-files:nil
- End:
- -->