Re: 7.1->7.2 data import timestamp problems

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