Re: How to include plpgsql in table pg_language

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: How to include plpgsql in table pg_language
Date: 2002-02-15 17:00:46
Message-ID: 20020215090000.R35996-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Fri, 15 Feb 2002, Pam Wampler wrote:

> I am trying to get a trigger/function to work & I think I need to use the
> plpgsql to do that --
> but I keep getting errors that the plpgsql is not in the table pg_language
> --
> What do I need to do to be able to use plpgsql?

Use the createlang script to add the language to the database.
createlang plpgsql database

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chad R. Larson 2002-02-15 17:38:54 Re: Porting to Win2000
Previous Message Alexandre Carmel-Veilleux 2002-02-15 16:29:57 Constant file growth.