I can confirm that current CVS sources have the same bug. > 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" <[EMAIL PROTECTED]> > > > > > 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 [EMAIL PROTECTED] so that your > > message can get through to the mailing list cleanly > > -- > Joseph Shraibman > [EMAIL PROTECTED] > Increase signal to noise ratio. http://www.targabot.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
