help with "plpgsql"

------=_Part_9689_25127697.1208792809126
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi everybody

I trying to upload some plpsql functions to postgresql database using a
per=
l
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=3D# CREATE LANGUAGE plpgsql;
ERROR:  language "plpgsql" already exists

anybody knows what's wrong?

Thanks

--=20
Pau Marc Mu=F1oz Torres

Laboratori de Biologia Computacional
Institut de  Biotecnologia   i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

tel=E8fon: 93 5812807
Email : paumarc.munoz@[EMAIL PROTECTED]
 text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi everybody<br><br>I trying to upload some plpsql functions to postgresql
=
database using a perl script and i get the following
error<br><br><br>&nbsp=
;psql:/usr/local/Make2D-DB_II/pgsql/make2db_functions.pgsql:85:
ERROR:&nbsp=
; language &quot;plpgsql&quot; does not exist<br>
HINT:&nbsp; Use CREATE LANGUAGE to load the language into the
database.<br>=
<br>and then when I try to create the language, i get<br><br><br>geldb=3D#
=
CREATE LANGUAGE plpgsql;<br>ERROR:&nbsp; language &quot;plpgsql&quot;
alrea=
dy exists<br>
<br>anybody knows what&#39;s wrong?<br><br>Thanks<br clear=3D"all"><br>--
<=
br>Pau Marc Mu=F1oz Torres<br><br>Laboratori de Biologia
Computacional&nbsp=
;&nbsp; <br>Institut de&nbsp;&nbsp;Biotecnologia&nbsp;&nbsp; i Biomedicina
=
Vicent
Villar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;<br>
Universitat Autonoma de Barcelona<br>
E-08193 Bellaterra
(Barcelona)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>tel=E8fon: 93
5812807<br>Ema=
il : paumarc.munoz@[EMAIL PROTECTED]