PostgreSQL 7.3 Documentation (DROP LANGUAGE)

Synopsis

DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]

name: The name of an existing procedural language. For backward compatibility, the name may be enclosed by single quotes.
CASCADE: Automatically drop objects that depend on the language (such as functions in the language).
RESTRICT: Refuse to drop the language if there are any dependent objects. This is the default.

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

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

The DROP PROCEDURAL LANGUAGE statement is a PostgreSQL language extension.

Refer to CREATE LANGUAGE for information on how to create procedural languages.