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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
