From: | "Keith Worthington" <keithw(at)narrowpathinc(dot)com> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org>, Keith Worthington <keithw(at)narrowpathinc(dot)com> |
Cc: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: language "plpgsql" does not exist |
Date: | 2004-12-17 00:11:10 |
Message-ID: | 20041217001110.M53784@narrowpathinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> On Thu, Dec 16, 2004 at 06:02:04PM -0500, Keith Worthington wrote:
>
> > I am trying to build a function to insert or update data
> > in one table from date stored in another table. Eventually
> > I hope to trigger this process based on data being INSERTed
> > into the original table. I have written the code below
> > based on the documentation and some help from this list.
> > When I execute the code I get this error.
> >
> > ERROR: language "plpgsql" does not exist
>
> Run createlang or CREATE LANGUAGE.
>
> http://www.postgresql.org/docs/7.4/static/xplang.html
> http://www.postgresql.org/docs/7.4/static/app-createlang.html
> http://www.postgresql.org/docs/7.4/static/sql-createlanguage.html
>
> If you want all newly-created databases to have the language, then
> create it in template1.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
Great!
I am finding my way around the documentation better
all the time. :-)
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com
From | Date | Subject | |
---|---|---|---|
Next Message | Afton & Ray Still | 2004-12-17 00:26:30 | Re: basic download and setup questions |
Previous Message | Michael Fuhr | 2004-12-16 23:47:37 | Re: language "plpgsql" does not exist |