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