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

Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <jeanmarc(dot)eber(at)lexifi(dot)com>, <dpage(at)vale-housing(dot)co(dot)uk>
Cc: <cmcdevitt(at)greenplum(dot)com>, <pgsql-hackers-win32(at)postgresql(dot)org>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC
Date: 2005-09-10 14:29:08
Message-ID: 00ae01c5b614$063e58da$6a01a8c0@valehousing.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
-----Original Message-----
From: "Jean-Marc EBER"<jeanmarc(dot)eber(at)lexifi(dot)com>
Sent: 10/09/05 14:26:15
To: "Dave Page"<dpage(at)vale-housing(dot)co(dot)uk>
Cc: "Chuck McDevitt"<cmcdevitt(at)greenplum(dot)com>, "pgsql-hackers-win32(at)postgresql(dot)org"<pgsql-hackers-win32(at)postgresql(dot)org>, "PostgreSQL-development"<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio & MSVC

>. This would imply that the 
> binary native win32 distribution of 
> postgresql contains (or that a 
> supplementary 
> package exists) the libraries (and headers) > that are necessary. Having these 
> libraries in mingw format would be nice, 
> having them for VC++ would probably be 
> very helpful to some of us.

Err, they (libpq and ecpglib) are included in both formats. Admittedley 8.0 missed some headers, but that is already fixed for 8.1. 

Regards, Dave

-----Unmodified Original Message-----
Hi all,

A remark linked to the preceding discussion:

Even if I could find some interest in compiling postgresql with Microsoft’s C 
compiler, I understand the technical and organizational difficulties implied by 
such a feature. If I want to rebuild from sources postgresql, I have to go the 
developers way, here use the mingw toolchain.

I think that writing _extensions_ for postgresql is another story.

Even before version 8.0, the binary win32/cygwin distribution contained 
precompiled libraries for client side programming with VisualC. This allows you 
to write postgresql client code in VC _and_ without rebuilding postgresql yourself.

Something similar (I think it has been discussed earlier but don’t remember the 
decisions) should exist for writing UDFs (stored procedures, the main reason for 
our use of postgresql compared to commercial databases where this feature is 
generally badly documented, to say the least). It would be nice if this was 
possible _without_ rebuilding postgresql from sources. This would imply that the 
binary native win32 distribution of postgresql contains (or that a supplementary 
package exists) the libraries (and headers) that are necessary. Having these 
libraries in mingw format would be nice, having them for VC++ would probably be 
very helpful to some of us.

Jean-Marc


Dave Page wrote:
>  
> 
>     ------------------------------------------------------------------------
>     *From:* pgsql-hackers-owner(at)postgresql(dot)org
>     [mailto:pgsql-hackers-owner(at)postgresql(dot)org] *On Behalf Of *Chuck
>     McDevitt
>     *Sent:* 09 September 2005 19:38
>     *To:* pgsql-hackers-win32(at)postgresql(dot)org
>     *Cc:* PostgreSQL-development
>     *Subject:* [HACKERS] Build with Visual Studio & MSVC
> 
>     Just for fun, I went through PostgreSQL 8.1 and did a complete build
>     using Microsoft’s C and the latest Visual Studio.
> 
>     With a few minor tweaks, everything compiled with no errors.
> 
>      
> 
>     My assumption is that because PostgreSQL is a UNIX/Linux-centric
>     project (and gcc/gdb centric), this really isn’t of much interest to
>     anyone.
> 
>     So other than this e-mail, I don’t plan to do anything with this
>     except for my own amusement.
> 
>      
> 
>     If I’m wrong, and there is some real interest in supporting MSVC,
>     let me know, and I’ll put some work into cleaning it up and making
>     patches out of it, etc. 
> 
>      
> 
> Hi Chuck,
> 
>  
> 
> We discussed this again on list only the other day in fact! Basically 
> we're not particulalry interested in supporting VS prject files in place 
> of gmake/autoconf, purely because they will undoubtedly cause 
> maintenance headaches as the majority of our developers don't have 
> Windows boxes, let alone a copy of Visual Studio.
> 
>  
> 
> However, if you need something to keep yourself amused (unless I can 
> persuade you to come help out with psqlODBC :-) ), we would be 
> interested in patches that allow us to use Microsoft's compiler as an 
> alternative to gcc.
> 
>  
> 
> It's interesting to know it built fairly easily though...
> 
>  
> 
> Regards, Dave.
> 
>  
> 
>  
> 



pgsql-hackers by date

Next:From: Andrew DunstanDate: 2005-09-10 16:10:19
Subject: FAQ/HTML standard?
Previous:From: Jean-Marc EBERDate: 2005-09-10 13:23:38
Subject: Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC

pgsql-hackers-win32 by date

Next:From: Oliver JowettDate: 2005-09-12 00:59:46
Subject: Re: [PATCHES] Implement support for TCP_KEEPCNT, TCP_KEEPIDLE, TCP_KEEPINTVL
Previous:From: Jean-Marc EBERDate: 2005-09-10 13:23:38
Subject: Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC

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