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@xxxxxxxxxxx
---------------------------(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
