Re: Warning for missing createlang

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Warning for missing createlang
Date: 2003-09-05 01:33:20
Message-ID: 200309050133.h851XKm25574@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > 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:
>
> > 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.
>
> I still agree with Peter's opinion ... this hint is fairly silly,
> especially since it would pop out for simple misspellings of language
> names.

What can we do to help people remember they have forgotten to load the
language? The post that question here too often. I don't see any
problem with a hint that starts with "Perhaps".

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2003-09-05 01:35:06 Re: Seqscan in MAX(index_column)
Previous Message Tom Lane 2003-09-05 01:28:56 Re: Warning for missing createlang

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-09-05 02:06:33 Re: libpq with ssl under win32
Previous Message Tom Lane 2003-09-05 01:28:56 Re: Warning for missing createlang