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

From Adrian Klaver
Subject Re: After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist
Date
Msg-id 200801100806.34099.aklaver@comcast.net
Whole thread Raw
In response to After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist  (Robin-Vossen <robin-vossen@hotmail.com>)
List 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@comcast.net

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Setting variables equal to elements from an Array
Next
From: Martijn van Oosterhout
Date:
Subject: Re: 8.2.4 serious slowdown