| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | 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-16 23:47:37 |
| Message-ID: | 20041216234737.GB8689@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Worthington | 2004-12-17 00:11:10 | Re: language "plpgsql" does not exist |
| Previous Message | Afton & Ray Still | 2004-12-16 23:38:20 | Re: basic download and setup questions |