You can also create the language in template1 and then you'll have it in any
other database you'll create (from template1).
Il Wednesday 31 October 2007 08:21:08 Martijn van Oosterhout ha scritto:
> On Wed, Oct 31, 2007 at 11:07:36AM +0800, carter ck wrote:
> > Hi all,
> >
> > I was trying to create function in postgres, but it returns error
> > mentioning the language is NOT defined.
>
> <snip>
>
> > ERROR: language "plpgsql" does not exist
> > HINT: Use CREATE LANGUAGE to load the language into the database.
> >
> > I was wonderring why it is not included by default? Or have I missed out
> > something in the configuration!
>
> It's included by default, just not enabled by default. Try "create
> language plpgsql" as administrator.
>
> > Also, how to do a better text search? I have come across the bad
> > performance of LIKE statement.
>
> See tsearch2.
>
> Have a nice day,
--
Reg me Please