Skip site navigation (1) Skip section navigation (2)

Re: Installing procedural language(s)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Burski <John(dot)Burski(at)911ep(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Installing procedural language(s)
Date: 2001-11-09 04:16:50
Message-ID: 19079.1005279410@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: John BurskiDate: 2001-11-09 15:12:45
Subject: Re: Installing procedural language(s)
Previous:From: Josh BerkusDate: 2001-11-09 04:11:38
Subject: Re: It's dead and won't get up!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group