Re: help with "plpgsql"

------=_Part_9733_19539802.1208793065942
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
exis=
t
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<br>/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><br>and then when I try to create the language, i get<br><br>geldb=3D#
=
CREATE LANGUAGE plpgsql;<br><br>ERROR:&nbsp; language &quot;plpgsql&quot;
a=
lready exists<br>
<br>anybody knows what&#39;s wrong?<br><br>Thanks<br><br>-- <br>Pau Marc
Mu=
=F1oz Torres<br><br>Laboratori de Biologia Computacional&nbsp;&nbsp;
<br>In=
stitut de&nbsp;&nbsp;Biotecnologia&nbsp;&nbsp; i Biomedicina Vicent
Villar&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
Universitat Autonoma de Barcelona<br>E-08193 Bellaterra
(Barcelona)<br>&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;<br>tel=E8fon: 93 5812807<br>Email : paumarc.munoz@[EMAIL PROTECTED]