Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group