Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger using function written in PL/PGSQL returns "Unrecognized language specified" - Mailing list pgsql-general

From jdassen@cistron.nl (J.H.M. Dassen (Ray))
Subject Re: Trigger using function written in PL/PGSQL returns "Unrecognized language specified"
Date
Msg-id slrn98acmc.9fr.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to Trigger using function written in PL/PGSQL returns "Unrecognized language specified"  (Dan B <db@cyclonehq.dnsalias.net>)
List pgsql-general
Tree view 
Dan B <db@cyclonehq.dnsalias.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

pgsql-general by date:

Previous
From: "PAOLA MANZO"
Date:
Subject: Consulta
Next
From: Peter Eisentraut
Date:
Subject: Re: Varchar and indexing..