Re: language "plpgsql" does not exist - Mailing list pgsql-novice

From Keith Worthington
Subject Re: language "plpgsql" does not exist
Date
Msg-id 20041217001110.M53784@narrowpathinc.com
Whole thread Raw
In response to Re: language "plpgsql" does not exist  (Michael Fuhr <mike@fuhr.org>)
List 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


pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: language "plpgsql" does not exist
Next
From: Afton & Ray Still
Date:
Subject: Re: basic download and setup questions