From: | Brent Gulanowski <bgulanowski(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | mclark(at)marketcircle(dot)com |
Subject: | PG COPY from version 8 to 9 issue with timezonetz |
Date: | 2011-03-17 17:10:49 |
Message-ID: | AANLkTikw+oXKEO77FEUgq_Lmn6d-DZpn0XvgdQ4bkuow@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 this case, the source computer is running Mac OS X 10.6.6 on x86_64
(MacBook Pro Core i5), and the destination computer is running Debian Lenny
on Xeon (Core i7).
I looked at the documentation on the copy command, and the PG9 release
notes, but I didn't see anything that might explain this problem.
We are using the WITH BINARY option. It has been suggested to disable that.
What are the down sides of that? I'm guessing just performance with binary
columns.
--
#pragma mark signature
[[self mailClient] send:[Mail messageWithText:@"From: Brent Gulanowski\nTo:
You"];
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Abbate | 2011-03-17 17:27:10 | regclass and search_path |
Previous Message | Scott Ribe | 2011-03-17 16:13:19 | Re: Primary key vs unique index |