Re: help with "plpgsql"

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