Question for Tom Lockhart: pg_dump is generating some dates that look like: '2002-09-09 02:11:60.00' or '2002-10-31 23:59:60.00'. psql <dbname> -f <pg_dump output file> doesn't like these dates. I can sed the :60 to a :59 but -- in the latter case it moves the date backwards a day, which doesn't work for my app. I understand from reading some of the list threads that there's a good reason to allow for "second" field values greater than 59, and per an email thread I had with Tom Lane, this has been addressed -- that it was a rounding error issue on some platforms.
I'm running postgres 7.2.2 on slackware 8.1 (kernel 2.4.18). Is there a workaround on this? Tks and kind regards, Martin Crundall ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
