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.

                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to