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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general