Re: [PATCHES] Warning for missing createlang

Bruce Momjian wrote:

>Bruce Momjian wrote:
>  
>
>>I have written a patch to issue an hint if someone tries to create a
>>function in a language that isn't loaded into the database:
>>
>>    test=> CREATE FUNCTION xx() RETURNS INT AS '
>>    test'> select 1'
>>    test-> LANGUAGE 'plpgsql';
>>    ERROR:  language "plpgsql" does not exist
>>    HINT:  Perhaps you need to use 'createlang' to load the language into
>>    the database.
>>
>>I know Peter didn't like this idea in the past, but we are getting too
>>many people who forget createlang, and with our new HINT tags, it seems
>>appropriate.
>>    
>>
>
>OK, Peter and Tom don't like it.  :-(
>
>How about this, that also suggests you mistyped the name:
>
>  
>
>>    HINT:  Perhaps you need to use 'createlang' to load the language into
>>    the database, or you mistyped the language name.
>>    
>>
>
>                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>

Why not list out the languages we *do* know about, and tell them it's 
not in the list? Or is that too much work?

andrew