From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | tamsin <tg_mail(at)bryncadfan(dot)co(dot)uk>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Bad timestamp external representation |
Date: | 2001-07-24 19:57:00 |
Message-ID: | 3B5DD30C.82E0E9CC@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)bryncadfan(dot)co(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Finn | 2001-07-24 22:21:26 | Re: Referential cascade technique |
Previous Message | Lee Harr | 2001-07-24 19:26:07 | Re: pqReadData() -- backend closed the channel unexpectedly. |
From | Date | Subject | |
---|---|---|---|
Next Message | John Gray | 2001-07-25 00:15:21 | Re: Storing XML in PostgreSQL |
Previous Message | Richard Huxton | 2001-07-24 13:55:18 | RAISE <level> <expr> <params>: state of play and request for advice |