I trying to upload some plpsql functions to postgresql database using a perl script and i get the following error
psql:/usr/local/Make2D-DB_II /pgsql/make2db_functions.pgsql:85: ERROR: language "plpgsql" does not exist HINT: Use CREATE LANGUAGE to load the language into the database.
and then when I try to create the language, i get
geldb=# CREATE LANGUAGE plpgsql;
ERROR: language "plpgsql" already exists
anybody knows what's wrong?
Thanks
-- Pau Marc Muñoz Torres
Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona)