Skip site navigation (1) Skip section navigation (2)

Re: 8.3b2: problem using "COPY ... TO/FROM .... BINARY"

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Thomas H(dot)" <me(at)alternize(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.3b2: problem using "COPY ... TO/FROM .... BINARY"
Date: 2007-11-19 17:01:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Sun, 2007-11-18 at 20:38 -0500, Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
> > On Sat, 2007-11-17 at 21:13 +0100, Thomas H. wrote:
> >>> 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
> > That means Tom is right, as usual :-)
> > 8.3 is built with integer timestamps, 8.2 and earlier with float
> > timestamps.
> Hmm, is that documented as a version discrepancy for the Win32 builds?
> IIRC we had rough consensus for switching the default setting to integer
> timestamps in 8.4.  Perhaps it would be better for the Win32 build to
> wait till 8.4 before switching, for consistency with other platforms.

The switch is in that it's the default on the MSVC build. So two
different decisions (making that the default on MSVC, and making the
MSVC build the default) together made that third.

I'm fine dropping the default on MSVC until 8.4, if it's going to happen
then. The downside then is that people won't be able to upgrade to the
next beta without initdb, right? Which isn't too good, but it's better
to make such a change during beta than to have to do it during


In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2007-11-19 18:41:46
Subject: Re: BUG #3760: Comment on restore database
Previous:From: Peter EisentrautDate: 2007-11-19 16:47:08
Subject: Re: BUG #3758: Postmaster Service

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group