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 [create_language(l)] for informa­
       tion on how to create 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.


Man(1) output converted with man2html