Re: [SQL] Problem with PL/pgSQL

From: Vince Gonzalez <vince(at)nycrc(dot)net>
To: Vladimir Terziev <vlady(at)school(dot)digsys(dot)bg>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Problem with PL/pgSQL
Date: 2000-02-08 14:09:47
Message-ID: 20000208090947.A31471@newton.baruch.cuny.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Vladimir Terziev 2000-02-08 14:48:18 Re: [SQL] Problem with PL/pgSQL
Previous Message Vladimir Terziev 2000-02-08 13:46:14 Problem with PL/pgSQL