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

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match