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 [EMAIL PROTECTED]
---------------------------(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