Re: Help on Trugger/Function

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Help on Trugger/Function
Date: 2002-02-21 19:54:51
Message-ID: 20020221115408.N21441-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 14 Feb 2002, Pam Wampler wrote:

> I am new to postgresql -- I am trying to create a trigger on a table --
> I get this error on the function
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> Recognized languages are sql, C, internal, and created procedural
> languages.

You'll need to use createlang to add the plpgsql language to the database
(it's not added by default).
I believe it's
createlang plpgsql <database>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-02-21 20:05:59 Re: [HACKERS] fmgr_info: function 20071: cache lookup failed
Previous Message Tom Lane 2002-02-21 19:10:05 Re: \connect case-folding change maybe not such a good idea