Re: Bad timestamp external representation

From: "tamsin" <tg_mail@bryncadfan.co.uk>

> Hi,
>
> Just created a db from a pg_dump file and got this error:
>
> ERROR:  copy: line 602, Bad timestamp external representation '2000-10-03
> 09:01:60.00+00'
>
> I guess its a bad representation because 09:01:60.00+00 is actually 09:02,
> but how could it have got into my database/can I do anything about it?
The
> value must have been inserted by my app via JDBC, I can't insert that
value
> directly via psql.

Seem to remember a bug in either pg_dump or timestamp rendering causing
rounding-up problems like this. If no-one else comes up with a definitive
answer, check the list archives. If you're not running the latest release,
check the change-log.

HTH

- Richard Huxton