We have pgsql-7.0.2 running on a production platform doing nightly dumps. I
tried to import this dump using psql to a pgsql server running from a cvs
update of 7.1 I did today.
All the data was imported OK except for the data in one table where I got
the following message on import :
ERROR: copy: line 154391, Bad timestamp external representation '2000-10-24 15:14:60.00+02'
PQendcopy: resetting connection
The result was that this table turned up with no rows at all after the
import when it should have contained more than 900000 rows.
I get exactly the same error trying to import into a 7.0.2 database on
my laptop as well, so I guess the problem might have been around for a
while.
The production platform creating the dump file is Solaris 7 on an Ultra
Sparc, while the laptop I'm importing the file on is Redhat Linux 6.1 on an
x86 processor.
The actual table "access_log" got these columns :
a_accesstime timestamp 8
a_locid int4 4
a_catid int4 4
a_searchterm varchar 256
a_host varchar 64
a_requesturl varchar 128
a_action varchar 16
a_uid int4 4
a_pt_id int4 4
Do anybody have suggestions to where I should look for the error or what
other data I need to supply to help somebody look into it ?
If you look at the seconds part of the time above you notice 60, which make
me wonder how that could get in there in the first place.
So to me there seems to bugs, it is possible to get invalid times into the
database and dump/restore breaks if you manage this.
regards,
Gunnar