Re: A creepy story about dates. How to prevent it?

=?iso-8859-1?Q?Conxita_Mar=EDn?= <comarin@telefonica.net> writes:
> I suggest that maybe the pg_dump has to store the datestyle in order to
> prevent this problems, no?

In 7.3.3 and later, pg_dump forces ISO datestyle while dumping, to
forestall exactly this problem.  Sorry that you got bit.

When you're doing an update, it's often a good idea to use the newer
version's pg_dump to extract the data from the older database.  We
keep pg_dump compatible with back versions (presently it handles
anything back to 7.0) so that you can take advantage of bugfixes in
newer pg_dumps.  Like this one ...

			regards, tom lane