From cmcdevitt@greenplum.com Fri Sep 9 18:38:18 2005 X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3D10CD873A; Fri, 9 Sep 2005 15:38:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68017-07; Fri, 9 Sep 2005 18:38:11 +0000 (GMT) Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by svr1.postgresql.org (Postfix) with ESMTP id BF86BD8642; Fri, 9 Sep 2005 15:38:08 -0300 (ADT) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Fri, 09 Sep 2005 14:37:55 -0400 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.174]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 9 Sep 2005 14:37:55 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Build with Visual Studio & MSVC Date: Fri, 9 Sep 2005 14:37:37 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Build with Visual Studio & MSVC Thread-Index: AcW1bYzAYj4kBsy9ShadggAwcQ+VSQ== From: "Chuck McDevitt" To: pgsql-hackers-win32@postgresql.org Cc: "PostgreSQL-development" X-OriginalArrivalTime: 09 Sep 2005 18:37:55.0397 (UTC) FILETIME=[97DF1750:01C5B56D] X-WSS-ID: 6F3F09094J02611774-01-01 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5B56D.979DE10F" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 required=5 tests=[AWL=-0.000, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/513 X-Sequence-Number: 72910 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5B56D.979DE10F Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable 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. =20 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. =20 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. ------_=_NextPart_001_01C5B56D.979DE10F Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable

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.

------_=_NextPart_001_01C5B56D.979DE10F-- From dpage@vale-housing.co.uk Fri Sep 9 18:58:08 2005 X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 63FACD6E26; Fri, 9 Sep 2005 15:58:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89117-03; Fri, 9 Sep 2005 18:58:04 +0000 (GMT) Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by svr1.postgresql.org (Postfix) with ESMTP id D310DD8642; Fri, 9 Sep 2005 15:58:04 -0300 (ADT) Received: from mailgate.vale-housing.co.uk ([194.217.48.34] helo=vale-housing.co.uk) by anchor-post-34.mail.demon.net with esmtp (Exim 4.42) id 1EDo4Y-0004k9-Ek; Fri, 09 Sep 2005 18:58:02 +0000 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5B570.67AA968F" X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Subject: Re: Build with Visual Studio & MSVC Date: Fri, 9 Sep 2005 19:58:01 +0100 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [HACKERS] Build with Visual Studio & MSVC Thread-Index: AcW1bYzAYj4kBsy9ShadggAwcQ+VSQAAiIjQ From: "Dave Page" To: "Chuck McDevitt" , Cc: "PostgreSQL-development" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.048 required=5 tests=[AWL=0.047, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/514 X-Sequence-Number: 72911 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5B570.67AA968F Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =20 ________________________________ 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 =09 =09 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. =20 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. =20 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.=20 =20 Hi Chuck, =20 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.=20 =20 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. =20 It's interesting to know it built fairly easily though... =20 Regards, Dave. =20 =20 ------_=_NextPart_001_01C5B570.67AA968F Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
 


From: = pgsql-hackers-owner@postgresql.org=20 [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Chuck=20 McDevitt
Sent: 09 September 2005 19:38
To:=20 pgsql-hackers-win32@postgresql.org
Cc:=20 PostgreSQL-development
Subject: [HACKERS] Build with Visual = Studio=20 & MSVC

Just for fun, I went = through=20 PostgreSQL 8.1 and did a complete build using Microsoft’s C and = the latest=20 Visual Studio.

With a few minor tweaks, = everything compiled with no errors.

 

My assumption is that = because=20 PostgreSQL is a UNIX/Linux-centric project (and gcc/gdb centric), this = really=20 isn’t of much interest to anyone.

So other than this = e-mail, I don’t=20 plan to do anything with this except for my own=20 amusement.

 

If I’m=20 wrong, and there is some real interest in supporting MSVC, let me = know, and=20 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=20 in fact! Basically we're not particulalry interested in supporting VS = prject=20 files in place of gmake/autoconf, purely because they will undoubtedly = cause=20 maintenance headaches as the majority of our developers don't have = Windows=20 boxes, let alone a copy of Visual Studio.

 

However, if you need something to keep = yourself amused=20 (unless I can persuade you to come help out with psqlODBC :-) ), we = would be=20 interested in patches that allow us to use Microsoft's compiler as = an=20 alternative to gcc.

 

It's interesting to know it built fairly = easily=20 though...

 

Regards, Dave.

 

 

------_=_NextPart_001_01C5B570.67AA968F-- From jd@commandprompt.com Fri Sep 9 19:08:21 2005 X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 40511D8305; Fri, 9 Sep 2005 16:08:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03251-02; Fri, 9 Sep 2005 19:08:16 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 915E2D8304; Fri, 9 Sep 2005 16:08:09 -0300 (ADT) Received: from [192.168.1.55] (fc1smp [66.93.38.87]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id j89J4tdq027725; Fri, 9 Sep 2005 12:04:56 -0700 Message-ID: <4321DDAC.1060602@commandprompt.com> Date: Fri, 09 Sep 2005 12:08:28 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0.6-1.1.fc4 (X11/20050720) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dave Page Cc: Chuck McDevitt , pgsql-hackers-win32@postgresql.org, PostgreSQL-development Subject: Re: Build with Visual Studio & MSVC References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Fri, 09 Sep 2005 12:04:56 -0700 (PDT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 required=5 tests=[AWL=0.013] X-Spam-Level: X-Archive-Number: 200509/515 X-Sequence-Number: 72912 > 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/ From andrew@dunslane.net Fri Sep 9 19:18:25 2005 X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ED491D710D; Fri, 9 Sep 2005 16:18:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89117-10; Fri, 9 Sep 2005 19:18:21 +0000 (GMT) Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by svr1.postgresql.org (Postfix) with ESMTP id A7E3BD86A0; Fri, 9 Sep 2005 16:18:16 -0300 (ADT) Received: from [192.168.1.103] (cpe-024-211-165-134.nc.res.rr.com [24.211.165.134]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id j89IYND16060; Fri, 9 Sep 2005 13:34:23 -0500 Message-ID: <4321DFF1.10706@dunslane.net> Date: Fri, 09 Sep 2005 15:18:09 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.10) Gecko/20050719 Fedora/1.7.10-1.3.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dave Page Cc: Chuck McDevitt , pgsql-hackers-win32@postgresql.org, PostgreSQL-development Subject: Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC References: In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.042 required=5 tests=[AWL=0.042] X-Spam-Level: X-Archive-Number: 200509/516 X-Sequence-Number: 72913 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 From xfinger@bol.com.br Fri Sep 9 22:05:45 2005 X-Original-To: pgsql-hackers-win32-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D042AD86F1 for ; Fri, 9 Sep 2005 19:05:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68596-08 for ; Fri, 9 Sep 2005 22:05:42 +0000 (GMT) Received: from sankara2.bol.com.br (sankara2.bol.com.br [200.221.24.89]) by svr1.postgresql.org (Postfix) with ESMTP id E0204D7A82 for ; Fri, 9 Sep 2005 19:05:43 -0300 (ADT) Received: from adsl (unknown [172.26.5.245]) by sankara2.bol.com.br (Postfix) with SMTP id ADBC07B30; Fri, 9 Sep 2005 19:05:42 -0300 (BRT) Message-ID: <006001c5b58a$93c431b0$01fea8c0@adsl.com.br> From: "xfinger" To: "Chuck McDevitt" , References: Subject: Re: Build with Visual Studio & MSVC Date: Fri, 9 Sep 2005 19:05:19 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Sender-IP: 200.163.192.37 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.783 required=5 tests=[AWL=-0.593, DNS_FROM_RFC_POST=1.376] X-Spam-Level: X-Archive-Number: 200509/19 X-Sequence-Number: 3385 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. From jeanmarc.eber@lexifi.com Sat Sep 10 13:26:17 2005 X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5EA6CD8622 for ; Sat, 10 Sep 2005 10:26:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93819-06 for ; Sat, 10 Sep 2005 13:26:11 +0000 (GMT) Received: from smtp7.wanadoo.fr (smtp7.wanadoo.fr [193.252.22.24]) by svr1.postgresql.org (Postfix) with ESMTP id C4361D6E2A for ; Sat, 10 Sep 2005 10:26:12 -0300 (ADT) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf0704.wanadoo.fr (SMTP Server) with ESMTP id 0B4C314000B6 for ; Sat, 10 Sep 2005 15:26:14 +0200 (CEST) Received: from lexifi.com (ATuileries-151-1-40-34.w82-123.abo.wanadoo.fr [82.123.124.34]) by mwinf0704.wanadoo.fr (SMTP Server) with ESMTP id 6CE6714000AE; Sat, 10 Sep 2005 15:26:13 +0200 (CEST) X-ME-UUID: 20050910132613446.6CE6714000AE@mwinf0704.wanadoo.fr Message-ID: <4322DE5A.7090709@lexifi.com> Date: Sat, 10 Sep 2005 15:23:38 +0200 From: Jean-Marc EBER User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dave Page Cc: Chuck McDevitt , pgsql-hackers-win32@postgresql.org, PostgreSQL-development Subject: Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC References: In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/529 X-Sequence-Number: 72926 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@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. > > > > > From dpage@vale-housing.co.uk Sat Sep 10 14:29:15 2005 X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7FADDD83F0; Sat, 10 Sep 2005 11:29:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12324-09; Sat, 10 Sep 2005 14:29:11 +0000 (GMT) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id B9B19D6F4F; Sat, 10 Sep 2005 11:29:13 -0300 (ADT) Received: from mailgate.vale-housing.co.uk ([194.217.48.34] helo=vale-housing.co.uk) by anchor-post-33.mail.demon.net with esmtp (Exim 4.42) id 1EE6M1-00024h-As; Sat, 10 Sep 2005 14:29:17 +0000 Received: from 192.168.1.106 ([192.168.1.106]) by ratbert.vale-housing.co.uk ([192.168.1.106]) with Microsoft Exchange Server HTTP-DAV ; Sat, 10 Sep 2005 14:29:17 +0000 From: "Dave Page" To: , Cc: , , Subject: Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC Message-ID: <00ae01c5b614$063e58da$6a01a8c0@valehousing.co.uk> Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Date: Sat, 10 Sep 2005 15:29:08 +0100 MIME-Version: 1.0 thread-topic: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio & MSVC thread-index: AcW2FAY+yAXw9MYBTlalvErkRGaAcw== X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.587 required=5 tests=[AWL=-1.489, MSGID_DOLLARS=3.076] X-Spam-Level: * X-Archive-Number: 200509/522 X-Sequence-Number: 72919 -----Original Message----- From: "Jean-Marc EBER" Sent: 10/09/05 14:26:15 To: "Dave Page" Cc: "Chuck McDevitt", = "pgsql-hackers-win32@postgresql.org",= "PostgreSQL-development" Subject: Re: [pgsql-hackers-win32] [HACKERS] Build with Visual Studio & = MSVC >. This would imply that the=20 > binary native win32 distribution of=20 > postgresql contains (or that a=20 > supplementary=20 > package exists) the libraries (and headers) > that are necessary. = Having these=20 > libraries in mingw format would be nice,=20 > having them for VC++ would probably be=20 > 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.=20 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=E2=80=99s C=20 compiler, I understand the technical and organizational difficulties = implied by=20 such a feature. If I want to rebuild from sources postgresql, I have to = go the=20 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=20 precompiled libraries for client side programming with VisualC. This = allows you=20 to write postgresql client code in VC _and_ without rebuilding = postgresql yourself. Something similar (I think it has been discussed earlier but = don=E2=80=99t remember the=20 decisions) should exist for writing UDFs (stored procedures, the main = reason for=20 our use of postgresql compared to commercial databases where this = feature is=20 generally badly documented, to say the least). It would be nice if this = was=20 possible _without_ rebuilding postgresql from sources. This would imply = that the=20 binary native win32 distribution of postgresql contains (or that a = supplementary=20 package exists) the libraries (and headers) that are necessary. Having = these=20 libraries in mingw format would be nice, having them for VC++ would = probably be=20 very helpful to some of us. Jean-Marc Dave Page wrote: > =20 >=20 > = ------------------------------------------------------------------------ > *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 >=20 > Just for fun, I went through PostgreSQL 8.1 and did a complete = build > using Microsoft=E2=80=99s C and the latest Visual Studio. >=20 > With a few minor tweaks, everything compiled with no errors. >=20 > =20 >=20 > My assumption is that because PostgreSQL is a UNIX/Linux-centric > project (and gcc/gdb centric), this really isn=E2=80=99t of much = interest to > anyone. >=20 > So other than this e-mail, I don=E2=80=99t plan to do anything = with this > except for my own amusement. >=20 > =20 >=20 > If I=E2=80=99m wrong, and there is some real interest in = supporting MSVC, > let me know, and I=E2=80=99ll put some work into cleaning it up = and making > patches out of it, etc.=20 >=20 > =20 >=20 > Hi Chuck, >=20 > =20 >=20 > We discussed this again on list only the other day in fact! Basically=20 > we're not particulalry interested in supporting VS prject files in = place=20 > of gmake/autoconf, purely because they will undoubtedly cause=20 > maintenance headaches as the majority of our developers don't have=20 > Windows boxes, let alone a copy of Visual Studio. >=20 > =20 >=20 > However, if you need something to keep yourself amused (unless I can=20 > persuade you to come help out with psqlODBC :-) ), we would be=20 > interested in patches that allow us to use Microsoft's compiler as an=20 > alternative to gcc. >=20 > =20 >=20 > It's interesting to know it built fairly easily though... >=20 > =20 >=20 > Regards, Dave. >=20 > =20 >=20 > =20 >=20