Thread: help with "plpgsql"

Hi everybody

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)
              
telèfon: 93 5812807
Email : paumarc.munoz@bioinf.uab.cat

am  Mon, dem 21.04.2008, um 17:46:49 +0200 mailte Pau Marc Munoz Torres folgendes:
> Hi everybody
>
> 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?

Wild guess: you have different databases. The language exists in the
database 'geldb', but your perl-script works on an other database.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net