Thread: ERROR: language "plpgsql" does not exist

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 ?

-- script
CREATE FUNCTION sales_tax(INTEGER) RETURNS REAL AS
 '
 DECLARE
        subtotal ALIAS FOR $1;
 BEGIN
        return subtotal * 0.06;
 END;
 ' Language 'plpgsql';


--
-
Best Regards

              /'"`\  zzzZ  |
             ( - - )          |
---oooO--(_)--Oooo-----------------------------------------------------
Life Is A Journey,  Enjoy The Ride.
**********************************************************************
Michael Shi             Database Developer

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