Re: help with "plpgsql" - Mailing list pgsql-general

From A. Kretschmer
Subject Re: help with "plpgsql"
Date
Msg-id 20080423081355.GD8401@a-kretschmer.de
Whole thread Raw
In response to help with "plpgsql"  ("Pau Marc Munoz Torres" <paumarc.munoz@bioinf.uab.cat>)
List pgsql-general
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

pgsql-general by date:

Previous
From: BLazeD
Date:
Subject: Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!
Next
From: Craig Ringer
Date:
Subject: Re: Postgresql Help