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

Поиск
Список
Период
Сортировка
От jdassen@cistron.nl (J.H.M. Dassen (Ray))
Тема Re: Trigger using function written in PL/PGSQL returns "Unrecognized language specified"
Дата
Msg-id slrn98acmc.9fr.jdassen@odin.cistron-office.nl
обсуждение исходный текст
Ответ на Trigger using function written in PL/PGSQL returns "Unrecognized language specified"  (Dan B <db@cyclonehq.dnsalias.net>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "PAOLA MANZO"
Дата:
Сообщение: Consulta
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Varchar and indexing..