Build with Visual Studio & MSVC

________________________________

From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Chuck McDevitt
Sent: 09 September 2005 19:38
To: pgsql-hackers-win32@postgresql.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.

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...

What would be of interest to me, would be to know if there is an actual
gain to compiling with the Microsoft compiler. I understand the
maintenance issues but if the Microsoft compiler gives us 25% better
performance on Win32 then Mingw...

Sincerely,

Joshua D. Drake

Regards, Dave.

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Dave Page wrote:

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...

There is also a pgfoundry project for maintaining Visual Studio project
files. see http://pgfoundry.org/projects/vcproject/

cheers

andrew

Hi,

Sure there is interest in building with VS, at least i would. VS has great
debugging suport, i
mean the IDE. Would be nice to build Postgresql and psqlODBC under one VS
project.
I wonder if you could share your VS project and patch to do a complete
building?

thanks,

Alexander

-----Mensagem Original-----
De: Chuck McDevitt
Para: pgsql-hackers-win32@postgresql.org
Cc: PostgreSQL-development
Enviada em: sexta-feira, 9 de setembro de 2005 15:37
Assunto: [pgsql-hackers-win32] 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 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:

-----Original Message-----
From: "Jean-Marc EBER"<jeanmarc.eber@lexifi.com>
Sent: 10/09/05 14:26:15
To: "Dave Page"<dpage@vale-housing.co.uk>
Cc: "Chuck McDevitt"<cmcdevitt@greenplum.com>, "pgsql-hackers-win32@postgresql.org"<pgsql-hackers-win32@postgresql.org>, "PostgreSQL-development"<pgsql-hackers@postgresql.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: