=?iso-8859-1?Q?Conxita_Mar=EDn?= <comarin(at)telefonica(dot)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