Re: Trigger using function written in PL/PGSQL returns "Unrecognized language specified"

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger using function written in PL/PGSQL returns "Unrecognized language specified"
Date: 2001-02-10 12:24:47
Message-ID: slrn98acmc.9fr.jdassen@odin.cistron-office.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dan B <db(at)cyclonehq(dot)dnsalias(dot)net> wrote:
>ds-# LANGUAGE 'plpgsql'
>ds-# Error: ERROR: Unrecognized language specified in a CREATE FUNCTION:
>'plpgsql'. Recognized languages are sql, C, internal and the created
>procedural languages.

It looks like you haven't used createlang(1) to add plpgsql to the languages
recognised by the database you're working on.

HTH,
Ray
--
"Perhaps they spent some of the time writing the patent application. That
task was surely harder than thinking of the technique."
RMS on Amazon's 1-Click(R) patent,
http://linuxtoday.com/story.php3?sn=13652

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James Patterson 2001-02-10 13:22:25 Howto install postgresql 7.03 on Darwin 1.2
Previous Message Dan B 2001-02-10 11:08:30 Trigger using function written in PL/PGSQL returns "Unrecognized language specified"