Re: language "plpgsql" does not exist

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

In response to

Browse pgsql-novice by date

  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