Re: ERROR: language "plpgsql" does not exist

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Michael" <mshi(at)cityxpress(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: language "plpgsql" does not exist
Date: 2003-01-29 15:30:51
Message-ID: 200301291530.51633.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 23 Jan 2003 10:45 pm, Michael wrote:
> I just installed the PostgreSQL7.3.1 on a linux server and trying to create
> a function .
>
> I got the
> ERROR: language "plpgsql" does not exist
>
> Why? How can I solve this ?

You need to enable any procedural languages you want to use. See the reference
manual for the SQL "CREATE LANGUAGE" command or the "createlang" command-line
tool. It's also covered in the programmer's guide under installing procedural
languages

--
Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco J Reyes 2003-01-29 15:32:56 Re: Status of tablespaces
Previous Message Nigel J. Andrews 2003-01-29 15:20:11 Re: Firewalls and Postgres