Interesting date/time 60 second problem with Postgresql
Interesting date/time 60 second problem with Postgresql
We are in the process of moving an emergency servers old data from Postgresql 7.1 to 7.2 and I got a very odd ( read as sucky ) error when I went to psql -f the dump file. psql:/mnt/nfs/sql/replication_test.sql:603812: ERROR: copy: line 44060, Bad timestamp external representation '2002-10-07 09:55:60.00-07' psql:/mnt/nfs/sql/replication_test.sql:603812: lost synchronization with server, resetting connection neat eh? I looked in the database and it actually has that timestamp. Which btw is defaulted to "now()" I know there were time accuracy fixes put in, was this something that was fixed? Sincerely, Will LaShell
Re: Interesting date/time 60 second problem with Postgresql
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Will LaShell writes: > psql:/mnt/nfs/sql/replication_test.sql:603812: ERROR: copy: line 44060, > Bad timestamp external representation '2002-10-07 09:55:60.00-07' > I know there were time accuracy fixes put in, was this something that > was fixed? Yeah, this is an old bug. You'll need to use sed or something to find and fix the dump lines containing '60.00'. regards, tom lane