Re: Installing procedural language(s)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Installing procedural language(s)
Дата
Msg-id 19079.1005279410@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Installing procedural language(s)  (John Burski <John.Burski@911ep.com>)
Список pgsql-novice
John Burski <John.Burski@911ep.com> writes:
>  [ createlang problems ]

createlang does two steps: a CREATE FUNCTION command that adds a
"language handler" function, and then a CREATE LANGUAGE command
that references the function.  Apparently you have a database
in which the handler function already exists but the language
entry doesn't.  Recent versions of createlang try to cope with
this scenario but the 7.0.3 version wasn't very bright about it.

I'd suggest manually dropping the plpgsql_call_handler function,
and then createlang should run to completion.

It might be that you got into this state because of some unnoted
failure of a previous createlang attempt, so pay attention to
any error messages this time ...

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: It's dead and won't get up!!
Следующее
От: Guido
Дата:
Сообщение: ...