Re: [GENERAL] PG COPY from version 8 to 9 issue with timezonetz

2011-03-17 Thread Radosław Smogura
Adrian Klaver Thursday 17 March 2011 19:18:25 > On Thursday, March 17, 2011 10:10:49 am Brent Gulanowski wrote: > > We use PG COPY to successfully in PG 8 to copy a database between two > > servers. Works perfectly. > > > > When the target server is PG 9, *some* fields of type timezonetz end up >

Re: [GENERAL] PG COPY from version 8 to 9 issue with timezonetz

2011-03-17 Thread Adrian Klaver
On Thursday, March 17, 2011 10:10:49 am Brent Gulanowski wrote: > We use PG COPY to successfully in PG 8 to copy a database between two > servers. Works perfectly. > > When the target server is PG 9, *some* fields of type timezonetz end up > garbled. Basically the beginning of the string is wrong:

[GENERAL] PG COPY from version 8 to 9 issue with timezonetz

2011-03-17 Thread Brent Gulanowski
We use PG COPY to successfully in PG 8 to copy a database between two servers. Works perfectly. When the target server is PG 9, *some* fields of type timezonetz end up garbled. Basically the beginning of the string is wrong: 152037-01-10 16:53:56.719616-05 It should be 2011-03-16 or similar. In