Re: help with "plpgsql"

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