Re: [SQL] Problem with PL/pgSQL - Mailing list pgsql-sql

From Vince Gonzalez
Subject Re: [SQL] Problem with PL/pgSQL
Date
Msg-id 20000208090947.A31471@newton.baruch.cuny.edu
Whole thread Raw
In response to Problem with PL/pgSQL  ("Vladimir Terziev" <vlady@school.digsys.bg>)
List pgsql-sql
On Tue, Feb 08, 2000 at 03:46:14PM +0200, Vladimir Terziev wrote:
>     I try to create the next function:
<snip>
> The result is:
> ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.  
> Recognized languages are sql, C, internal and the created procedural languages.

You need to do createlang on the table, like so:

$ createlang plpgsql test

Where test is the database.

--vince


pgsql-sql by date:

Previous
From: "Vladimir Terziev"
Date:
Subject: Problem with PL/pgSQL
Next
From: "Vladimir Terziev"
Date:
Subject: Re: [SQL] Problem with PL/pgSQL