Re: installing from source in Windows

Hmmm.. seems like I'm in a dandy of a catch-22

On an earlier post
(http://archives.postgresql.org/pgsql-general/2010-09/msg01043.php) I
was inquiring about trying to add in Jeff Davis' temporal extension
package available from pgFoundry.

Based on the facts that:
 1) the temporal package installs by using pgxs and
 2) pgxs doesn't work with the Windows VC++ build

.. I thought it was worth a shot to try building from source with
MinGW/MSYS to get the pgxs files... but apparently not -- especially
since I'm on Windows XP 32-bit platform (hence the issue with 64-bit
datatypes bombing out during make, I presume)

So unless I've totally misunderstood, if I go the VC++ route, I can't
get pgxs, right?  And getting that tool to build/add-in extensions with
was my goal in the first place...

Thanks,
John

-----Original Message-----
From: Greg Smith [mailto:greg@2ndquadrant.com]
Sent: Sunday, October 17, 2010 10:47 PM
To: Turner, John J
Cc: Craig Ringer; Rob Sargent; pgsql-general@postgresql.org
Subject: Re: [GENERAL] installing from source in Windows

Turner, John J wrote:
> I'm reluctant at this point to wipe out my MinGW and MSYS and start
from
> scratch with Windows SDK and/or VS-ee...
>

Well, you should probably get over that, because all of the official
builds of 9.0 don't really care about supporting MinGW anymore.  See
http://www.postgresql.org/docs/9.0/interactive/install-windows.html for
notes on this.  I wouldn't be surprised to find the capability to build
with MinGW is broken in various ways now, because it doesn't get tested
anymore that I'm aware of.  I gave up on that toolchain the minute the
newer Visual Studio alternative was available, and tossing out MinGW for

this purpose has been nothing but an improvement for me.

--
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support  www.2ndQuadrant.us