| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Burski | 2001-11-09 15:12:45 | Re: Installing procedural language(s) |
| Previous Message | Josh Berkus | 2001-11-09 04:11:38 | Re: It's dead and won't get up!! |