Re: [GENERAL] DateStyle causes drama during upgrade

2000-08-22 Thread Andrew McMillan
Martijn van Oosterhout wrote: > > We used pg_dump in various ways, all with the date style "iso" > but always some of the dates appeared to be translated wrong. > Eventually we worked out that even though the datestyle was > set to "iso" on both machines, the old postgres read it as > "ISO with e

[GENERAL] DateStyle causes drama during upgrade

2000-08-21 Thread Martijn van Oosterhout
Hi, We were prototyping our system working with the new Postgres 7 so we set up a new machine with all the important programs and copied all the data to it. We used pg_dump in various ways, all with the date style "iso" but always some of the dates appeared to be translated wrong. Eventually we