From: Martin Crundall <pgsql@ac6rm.net>
To: pgsql-sql@postgresql.org
Subject: pg_dump / dates:
Date: Mon, 11 Nov 2002 21:15:53 -0800 (PST)
Message-ID: <64726.24.52.245.104.1037078153.squirrel@webmail.ac6rm.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgsql@ac6rm.net
Subject: Re: pg_dump / dates:
In-Reply-To: <64726.24.52.245.104.1037078153.squirrel@webmail.ac6rm.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox