| From: | Reg Me Please <regmeplease(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | carter ck <carterck32(at)hotmail(dot)com> |
| Subject: | Re: |
| Date: | 2007-10-31 07:41:44 |
| Message-ID: | 200710310841.45255.regmeplease@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joao Miguel Ferreira | 2007-10-31 09:56:40 | strange message from pg_dumpall |
| Previous Message | Christian Rengstl | 2007-10-31 07:21:45 | Re: |