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[1]. Now my concern is how the value 'current' found its way into a timestamp field.... I'm looking at the application. thank you. [1] - I did have to manually modify the pg_dump output to remove the quotes from around current_timestamp (as mentioned elsewhere). -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
