DROP LANGUAGE
SQL - Language Statements
DROP LANGUAGE
Removes a user-defined procedural language
1998-04-15
DROP PROCEDURAL LANGUAGE 'langname'
1998-04-15
Inputs
langname
The name of an existing language.
1998-04-15
Outputs
DROP
This message is returned if the language is successfully dropped.
ERROR: Language "langname" doesn't exist
This message occurs if the language
"langname" is
not found.
1998-04-15
Description
DROP PROCEDURAL LANGUAGE will remove the definition
of the previously registered procedural language having the name
'langname'.
1998-04-15
Notes
The DROP PROCEDURAL LANGUAGE statement is
a Postgres language extension.
Refer to CREATE PROCEDURAL LANGUAGE
for information on how to create procedural languages.
1998-04-15
Bugs
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.
Usage
This command removes the PL/Sample language:
DROP PROCEDURAL LANGUAGE 'plsample'
Compatibility
1998-04-15
SQL92
There is no DROP PROCEDURAL LANGUAGE in
SQL92.