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 200202231944.g1NJiEk43626@lists.unixathome.org
Whole thread Raw
In response to Re: 7.1->7.2 data import timestamp problems  ("Dan Langille" <dan@langille.org>)
Responses Re: 7.1->7.2 data import timestamp problems  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Dan Langille"
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