Pau Marc Munoz Torres wrote:
> 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
>
My first guess would be what db are you connected to?
Is the script connected to the same db you are connected to when you run
psql?
I would probably add the CREATE LANGUAGE command to the start of the
perl script.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz