John Burski <John(dot)Burski(at)911ep(dot)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
In response to
pgsql-novice by date
|Next:||From: John Burski||Date: 2001-11-09 15:12:45|
|Subject: Re: Installing procedural language(s)|
|Previous:||From: Josh Berkus||Date: 2001-11-09 04:11:38|
|Subject: Re: It's dead and won't get up!!|