On Sat, 2007-11-17 at 21:13 +0100, Thomas H. wrote: > tom lane wrote: > >> i'm not sure it its really a bug - the manual specifies that COPY ... > >> BINARY between different PGSQL versions might be problematic. > > > >> nevertheless: i've imported several tables from 8.2.5 to 8.3b2 without > >> any problems, until one table produced an error on a timestamp field: > > > > I'll bet a nickel that you built one version with float timestamps and > > the other with integer ... > > both versions are the official win32 builds from postgresl.org...
That means Tom is right, as usual :-) 8.3 is built with integer timestamps, 8.2 and earlier with float timestamps. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster