On 23 Feb 2002 at 16:06, Tom Lane wrote:
> Actually, under 7.2 the preferred definition is just
>
> CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS
> 'plpgsql', 'plpgsql_call_handler' LANGUAGE 'C';
Is there a correct way to replace such definitions? I tried just a drop
function and then a create function, but:
ERROR: fmgr_info: function 16557: cache lookup failed
> Almost certainly, the reason you got burnt to begin with was that
> the dumped definition of plpgsql_call_handler contained the full
> path to the *old* installation's plpgsql.so --- am I not right?
You are correct.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples