Re: After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Robin-Vossen <robin-vossen(at)hotmail(dot)com>
Subject: Re: After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist
Date: 2008-01-10 16:06:33
Message-ID: 200801100806.34099.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 09 January 2008 3:02 am, Robin-Vossen wrote:
> CREATE INDEX
> psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist
> HINT: You need to use "createlang" to load the language into the database.
<snip>
>
>
> So, I wonder what is the best and quickest way to fix this Flaw?
>
> Thanks,
> Robin
The solution is in the HINT:. The language needs to loaded with createlang.
plpgsql is shipped with Postgres it is not, however, loaded by default.
--
Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-01-10 16:07:00 Re: 8.2.4 serious slowdown
Previous Message Scott Marlowe 2008-01-10 16:01:46 Re: Setting variables equal to elements from an Array