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