Re: 7.1->7.2 data import timestamp problems

On 23 Feb 2002 at 14:28, Dan Langille wrote:

> On 23 Feb 2002 at 11:22, Sean Chittenden wrote:
>
> > > I've just been able to confirm that 7.1.2 can import the above data. My
> > > plans for 7.2 are now on hold while I try to find a way to get 7.2 to
> > > accept the data that has been exported from 7.1.
> >
> > perl -p -i -e 's#current#now#igo' pgsql_dump.sql
> >
> > Double check that you don't have the word 'current' in your dump other than
> > timestamps.
> >
> > grep -i current pgsql_dump.sql
> >
> > HTH -sc
>
> Sean: you are on the same track I am. Yes, I found 9 such values in a
> timestamp field. I corrected the data, exported, and imported into 7.2.
> All went well

I spoke too soon:

now I'm getting: ERROR: SearchSysCache: Bad cache id 27

But I'll try to track down more and see. Just a heads up in case this
raises any concerns with anyone.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples