Re: Installing procedural language(s) - Mailing list pgsql-novice

From Tom Lane
Subject Re: Installing procedural language(s)
Date
Msg-id 19079.1005279410@sss.pgh.pa.us
Whole thread Raw
In response to Installing procedural language(s)  (John Burski <John.Burski@911ep.com>)
List 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 by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: It's dead and won't get up!!
Next
From: Guido
Date:
Subject: ...