help with "plpgsql"

From: "Pau Marc Munoz Torres" <paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat>
To: "PgSQL General ML" <pgsql-general(at)postgresql(dot)org>
Subject: help with "plpgsql"
Date: 2008-04-21 15:46:49
Message-ID: 19b5841a0804210846y21ebf35csb1d4dc5e948b879d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
Pau Marc Muñoz Torres

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

telèfon: 93 5812807
Email : paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pau Marc Munoz Torres 2008-04-21 15:51:05 Re: help with "plpgsql"
Previous Message David Wall 2008-04-21 15:28:25 Re: JDBC addBatch more efficient?