| From: | "tamsin" <tg_mail(at)bryncadfan(dot)co(dot)uk> |
|---|---|
| To: | "Postgres General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Bad timestamp external representation |
| Date: | 2001-07-24 09:15:42 |
| Message-ID: | NEBBKHBOBMJCHDMGKCNJGEINDBAA.tg_mail@bryncadfan.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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 | Date | Subject | |
|---|---|---|---|
| Next Message | Michael A. Peters | 2001-07-24 10:16:57 | Re: OS X |
| Previous Message | Alessio Bragadini | 2001-07-24 08:55:08 | Re: epoch to show millseconds |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mlw | 2001-07-24 09:24:10 | Re: sub queries and caching. |
| Previous Message | Henshall, Stuart - WCP | 2001-07-24 07:53:51 | RE: RE: OID wraparound (was Re: pg_depend) |