DROP_LANGUAGE(l)                                 DROP_LANGUAGE(l)

NAME
       DROP LANGUAGE - Removes a user-defined procedural language

SYNOPSIS
       DROP PROCEDURAL LANGUAGE 'name'

   INPUTS
       name   The name of an existing procedural language.

   OUTPUTS
       DROP   This message is returned if the  language  is  suc-
              cessfully dropped.

       ERROR: Language "name" doesn't exist
              This  message  occurs  if a language called name is
              not found in the database.

DESCRIPTION
       DROP PROCEDURAL LANGUAGE will remove the definition of the
       previously registered procedural language called name.

   NOTES
       The  DROP PROCEDURAL LANGUAGE statement is a Postgres lan-
       guage extension.

       Refer to create_language(l) for information on how to cre-
       ate procedural languages.

       No checks are made if functions or trigger procedures reg-
       istered 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.

USAGE
       This command removes the PL/Sample language:

       DROP PROCEDURAL LANGUAGE 'plsample';

COMPATIBILITY
   SQL92
       There is no DROP PROCEDURAL LANGUAGE in SQL92.

SQL - Language Statements 15 August 1999                        1