Thread: Bad timestamp external representation
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. Thanks, Tamsin version --------------------------------------------------------------------- PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 (1 row)
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
It's a bug in timestamp output. # select '2001-07-24 15:55:59.999'::timestamp; ?column? --------------------------- 2001-07-24 15:55:60.00-04 (1 row) Richard Huxton wrote: > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com