| From: | "Richard Huxton" <dev(at)archonet(dot)com> |
|---|---|
| To: | "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 12:58:29 |
| Message-ID: | 004501c11440$56e51240$1001a8c0@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roderick A. Anderson | 2001-07-24 14:02:51 | [Summary] The 'C' Word |
| Previous Message | Larry Rosenman | 2001-07-24 12:58:15 | Re: Error in making Example Program |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-07-24 13:11:31 | Storing XML in PostgreSQL |
| Previous Message | mlw | 2001-07-24 09:24:10 | Re: sub queries and caching. |