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.