Re: Odd error in timestamp processing
От | Robert M. Meyer |
---|---|
Тема | Re: Odd error in timestamp processing |
Дата | |
Msg-id | 1027449659.25568.37.camel@skymaster обсуждение исходный текст |
Ответ на | Odd error in timestamp processing (Jeff Boes <jboes@nexcerpt.com>) |
Ответы |
Re: Odd error in timestamp processing
|
Список | pgsql-admin |
We had this problem, too. Very annoying. It appears to be a bug in 7.1.x. The way we got around it was to dump the DB out to a file and run sed on the file with the script: s/:60/:59/ Then feeding that output into psql. Of course, our database doesn't use ':' followed by numbers for anything but timestamps so your mileage may vary. Hope this helps... Cheers! Bob On Tue, 2002-07-23 at 14:14, Jeff Boes wrote: > Recently we transferred our database from a 7.1 system to a 7.2 using: > > $ pg_dump -h old_host | psql > > During this, we saw this message: > > > ERROR: copy: line 15926, Bad timestamp external representation > '2002-07-21 06:54:60.00-04' > > (It's the '60 seconds' part of the timestamp that is causing the problem, > I'm sure.) How might this have happened? Some kind of rounding error? > > -- > Jeff Boes vox 616.226.9550 ext 24 > Database Engineer fax 616.349.9076 > Nexcerpt, Inc. http://www.nexcerpt.com > ...Nexcerpt... Extend your Expertise > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Robert M. Meyer Sr. Network Administrator DigiVision Satellite Services 14 Lafayette Sq, Ste 410 Buffalo, NY 14203-1904 (716)332-1451
В списке pgsql-admin по дате отправления: