Re: 7.1->7.2 data import timestamp problems - Mailing list pgsql-admin

From Dan Langille
Subject Re: 7.1->7.2 data import timestamp problems
Date
Msg-id 200202232130.g1NLUEk44623@lists.unixathome.org
Whole thread Raw
In response to Re: 7.1->7.2 data import timestamp problems  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 7.1->7.2 data import timestamp problems
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.1->7.2 data import timestamp problems
Next
From: Tom Lane
Date:
Subject: Re: 7.1->7.2 data import timestamp problems