Building the psqlODBC enhanced branch (Windows)

This is a multi-part message in MIME format.

------_=_NextPart_001_01C63602.71D022AD
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Hiroshi,

I've just started looking at building a test release of the
psqlodbc-enhanced branch. I have the following on my machine:

- OpenSSL 0.98, binary distribution installed in C:\OpenSSL
- PostgreSQL 8.1.3 pgInstaller distribution installed in C:\Program
Files\PostgreSQL\8.1
- Visual Studio 6.0

This machine is the standard setup we use for pgInstaller, pgAdmin and
current psqlODBC builds, so I'm keen to be able to build this branch of
the code with as few changes as possible.

The attached patch contains the changes I made to get a build in this
environment using the command line, however I still got the following
warnings:

link.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma03328.
LINK : warning LNK4199: /DELAYLOAD:libpq ignored; no imports found from
libpq
LINK : warning LNK4199: /DELAYLOAD:ssleay32 ignored; no imports found
from ssleay32
Creating library .\Unicode30\psqlodbc.lib and object
..\Unicode30\psqlodbc.exp
LINK : warning LNK4199: /DELAYLOAD:libpq ignored; no imports found from
libpq
LINK : warning LNK4199: /DELAYLOAD:ssleay32 ignored; no imports found
from ssleay32

Anything to worry about there?

Regards, Dave.

------_=_NextPart_001_01C63602.71D022AD
Content-Type: application/octet-stream;
name="windows_build.diff"
Content-Transfer-Encoding: base64
Content-Description: windows_build.diff
Content-Disposition: attachment;
filename="windows_build.diff"

PyBkcC5kaWZmCj8gVW5pY29kZTMwCkluZGV4OiBsb2FkbGliLmMKPT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PQpSQ1MgZmlsZTogL2N2c3Jvb3QvcHNxbG9kYmMv
cHNxbG9kYmMvQXR0aWMvbG9hZGxpYi5jLHYKcmV0cmlldmluZyByZXZpc2lv
biAxLjEuMi41CmRpZmYgLWMgLXIxLjEuMi41IGxvYWRsaWIuYwoqKiogbG9h
ZGxpYi5jCTggRmViIDIwMDYgMDE6MTQ6MTMgLTAwMDAJMS4xLjIuNQotLS0g
bG9hZGxpYi5jCTIwIEZlYiAyMDA2IDA5OjMwOjQxIC0wMDAwCioqKioqKioq
KioqKioqKgoqKiogMjAsMjYgKioqKgogICNpZmRlZiAgV0lOMzIKICAjaWZk
ZWYgIF9NU0NfVkVSCiAgI3ByYWdtYSBjb21tZW50KGxpYiwgIkRlbGF5aW1w
IikKISAjcHJhZ21hIGNvbW1lbnQobGliLCAibGlicHFkbGwiKQogICNwcmFn
bWEgY29tbWVudChsaWIsICJzc2xlYXkzMiIpCiAgLy8gVGhlIGZvbGxvd2lu
Z3Mgd29ya3MgdW5kZXIgVkMrKzYuMCBidXQgZG9lc24ndCB3b3JrIHVuZGVy
IFZDKys3LjAuCiAgLy8gUGxlYXNlIGFkZCB0aGUgZXF1aXZhbGVudCBsaW5r
ZXIgb3B0aW9ucyB1c2luZyBjb21tYW5kIGxpbmUgZXRjLgotLS0gMjAsMjYg
LS0tLQogICNpZmRlZiAgV0lOMzIKICAjaWZkZWYgIF9NU0NfVkVSCiAgI3By
YWdtYSBjb21tZW50KGxpYiwgIkRlbGF5aW1wIikKISAjcHJhZ21hIGNvbW1l
bnQobGliLCAibGlicHEiKQogICNwcmFnbWEgY29tbWVudChsaWIsICJzc2xl
YXkzMiIpCiAgLy8gVGhlIGZvbGxvd2luZ3Mgd29ya3MgdW5kZXIgVkMrKzYu
MCBidXQgZG9lc24ndCB3b3JrIHVuZGVyIFZDKys3LjAuCiAgLy8gUGxlYXNl
IGFkZCB0aGUgZXF1aXZhbGVudCBsaW5rZXIgb3B0aW9ucyB1c2luZyBjb21t
YW5kIGxpbmUgZXRjLgpJbmRleDogd2luMzJfMzB3Lm1hawo9PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09ClJDUyBmaWxlOiAvY3Zzcm9vdC9wc3Fsb2RiYy9wc3Fs
b2RiYy9BdHRpYy93aW4zMl8zMHcubWFrLHYKcmV0cmlldmluZyByZXZpc2lv
biAxLjcuMi44CmRpZmYgLWMgLXIxLjcuMi44IHdpbjMyXzMwdy5tYWsKKioq
IHdpbjMyXzMwdy5tYWsJNiBGZWIgMjAwNiAxNDozNDoxMCAtMDAwMAkxLjcu
Mi44Ci0tLSB3aW4zMl8zMHcubWFrCTIwIEZlYiAyMDA2IDA5OjMwOjQ3IC0w
MDAwCioqKioqKioqKioqKioqKgoqKiogNDUsNTUgKioqKgogICFNRVNTQUdF
IFVzaW5nIGRlZmF1bHQgUG9zdGdyZVNRTCBMaWJyYXJ5IGRpcmVjdG9yeTog
JChQR19MSUIpCiAgIUVORElGCiAgCiEgIUlGIEVYSVNUKCIkKFBHX0xJQikv
bGlic3NsMzIuZGxsIikKISBTU0xfRExMID0gImxpYnNzbDMyLmRsbCIKISAh
RUxTRQohIFNTTF9ETEwgPSAiU1NMRUFZMzIuZGxsIgogICFFTkRJRgogIEFE
RF9ERUZJTkVTID0gJChBRERfREVGSU5FUykgL0QgIlNTTF9ETEw9XCIkKFNT
TF9ETEwpXCIiCiAgCiAgIUlGICIkKF9OTUFLRV9WRVIpIiA9PSAiNi4wMC45
NzgyLjAiCi0tLSA0NSw2MSAtLS0tCiAgIU1FU1NBR0UgVXNpbmcgZGVmYXVs
dCBQb3N0Z3JlU1FMIExpYnJhcnkgZGlyZWN0b3J5OiAkKFBHX0xJQikKICAh
RU5ESUYKICAKISAhSUYgIiQoU1NMX0lOQykiID09ICIiCiEgU1NMX0lOQz1D
OlxPcGVuU1NMXGluY2x1ZGUKISAhTUVTU0FHRSBVc2luZyBkZWZhdWx0IE9w
ZW5TU0wgSW5jbHVkZSBkaXJlY3Rvcnk6ICQoU1NMX0lOQykKISAhRU5ESUYK
ISAKISAhSUYgIiQoU1NMX0xJQikiID09ICIiCiEgU1NMX0xJQj1DOlxPcGVu
U1NMXGxpYlxWQwohICFNRVNTQUdFIFVzaW5nIGRlZmF1bHQgT3BlblNTTCBM
aWJyYXJ5IGRpcmVjdG9yeTogJChTU0xfTElCKQogICFFTkRJRgorIAorIFNT
TF9ETEwgPSAic3NsZWF5MzIuZGxsIgogIEFERF9ERUZJTkVTID0gJChBRERf
REVGSU5FUykgL0QgIlNTTF9ETEw9XCIkKFNTTF9ETEwpXCIiCiAgCiAgIUlG
ICIkKF9OTUFLRV9WRVIpIiA9PSAiNi4wMC45NzgyLjAiCioqKioqKioqKioq
KioqKgoqKiogMTI5LDEzNSAqKioqCiAgICAgIGlmIG5vdCBleGlzdCAiJChP
VVRESVIpLyQoTlVMTCkiIG1rZGlyICIkKE9VVERJUikiCiAgCiAgQ1BQPWNs
LmV4ZQohIENQUF9QUk9KPS9ub2xvZ28gL01UIC9XMyAvR1ggL08yIC9JICQo
UEdfSU5DKSAvRCAiV0lOMzIiIC9EICJOREVCVUciIC9EICJfV0lORE9XUyIg
L0QgIl9NQkNTIiAvRCAiX1VTUkRMTCIgL0QgIlBTUUxPREJDX0VYUE9SVFMi
IC9EICJPREJDVkVSPTB4MDM1MSIgL0QgIlVOSUNPREVfU1VQUE9SVCIgL0Qg
IldJTl9NVUxUSVRIUkVBRF9TVVBQT1JUIiAkKEFERF9ERUZJTkVTKSAvRnAi
JChJTlRESVIpXHBzcWxvZGJjLnBjaCIgL1lYIC9GbyIkKElOVERJUilcXCIg
L0ZkIiQoSU5URElSKVxcIiAvRkQgL2MgCiAgCiAgLmN7JChJTlRESVIpfS5v
Ymo6OgogICAgICQoQ1BQKSBAPDwKLS0tIDEzNSwxNDEgLS0tLQogICAgICBp
ZiBub3QgZXhpc3QgIiQoT1VURElSKS8kKE5VTEwpIiBta2RpciAiJChPVVRE
SVIpIgogIAogIENQUD1jbC5leGUKISBDUFBfUFJPSj0vbm9sb2dvIC9NVCAv
VzMgL0dYIC9PMiAvSSAiJChQR19JTkMpIiAvSSAiJChTU0xfSU5DKSIgL0Qg
IldJTjMyIiAvRCAiTkRFQlVHIiAvRCAiX1dJTkRPV1MiIC9EICJfTUJDUyIg
L0QgIl9VU1JETEwiIC9EICJQU1FMT0RCQ19FWFBPUlRTIiAvRCAiT0RCQ1ZF
Uj0weDAzNTEiIC9EICJVTklDT0RFX1NVUFBPUlQiIC9EICJXSU5fTVVMVElU
SFJFQURfU1VQUE9SVCIgJChBRERfREVGSU5FUykgL0ZwIiQoSU5URElSKVxw
c3Fsb2RiYy5wY2giIC9ZWCAvRm8iJChJTlRESVIpXFwiIC9GZCIkKElOVERJ
UilcXCIgL0ZEIC9jIAogIAogIC5jeyQoSU5URElSKX0ub2JqOjoKICAgICAk
KENQUCkgQDw8CioqKioqKioqKioqKioqKgoqKiogMTcxLDE3NyAqKioqCiAg
CQogIExJTkszMj1saW5rLmV4ZQogIERFRl9GSUxFPSAicHNxbG9kYmNfYXBp
MzB3LmRlZiIKISBMSU5LMzJfRkxBR1M9a2VybmVsMzIubGliIHVzZXIzMi5s
aWIgZ2RpMzIubGliIHdpbnNwb29sLmxpYiBjb21kbGczMi5saWIgYWR2YXBp
MzIubGliIHNoZWxsMzIubGliIG9sZTMyLmxpYiBvbGVhdXQzMi5saWIgdXVp
ZC5saWIgb2RiYzMyLmxpYiBvZGJjY3AzMi5saWIgd3NvY2szMi5saWIgL25v
bG9nbyAvZGxsIC9pbmNyZW1lbnRhbDpubyAvcGRiOiIkKE9VVERJUilccHNx
bG9kYmMucGRiIiAvbWFjaGluZTpJMzg2IC9kZWY6IiQoREVGX0ZJTEUpIiAv
b3V0OiIkKE9VVERJUkJJTilccHNxbG9kYmMzNXcuZGxsIiAvaW1wbGliOiIk
KE9VVERJUilccHNxbG9kYmMubGliIiAiJChWQzA3X0RFTEFZX0xPQUQpIiAv
bGlicGF0aDoiJChQR19MSUIpIgogIExJTkszMl9PQkpTPSBcCiAgCSIkKElO
VERJUilcYmluZC5vYmoiIFwKICAJIiQoSU5URElSKVxjb2x1bW5pbmZvLm9i
aiIgXAotLS0gMTc3LDE4MyAtLS0tCiAgCQogIExJTkszMj1saW5rLmV4ZQog
IERFRl9GSUxFPSAicHNxbG9kYmNfYXBpMzB3LmRlZiIKISBMSU5LMzJfRkxB
R1M9a2VybmVsMzIubGliIHVzZXIzMi5saWIgZ2RpMzIubGliIHdpbnNwb29s
LmxpYiBjb21kbGczMi5saWIgYWR2YXBpMzIubGliIHNoZWxsMzIubGliIG9s
ZTMyLmxpYiBvbGVhdXQzMi5saWIgdXVpZC5saWIgb2RiYzMyLmxpYiBvZGJj
Y3AzMi5saWIgd3NvY2szMi5saWIgL25vbG9nbyAvZGxsIC9pbmNyZW1lbnRh
bDpubyAvcGRiOiIkKE9VVERJUilccHNxbG9kYmMucGRiIiAvbWFjaGluZTpJ
Mzg2IC9kZWY6IiQoREVGX0ZJTEUpIiAvb3V0OiIkKE9VVERJUkJJTilccHNx
bG9kYmMzNXcuZGxsIiAvaW1wbGliOiIkKE9VVERJUilccHNxbG9kYmMubGli
IiAiJChWQzA3X0RFTEFZX0xPQUQpIiAvbGlicGF0aDoiJChQR19MSUIpIiAv
bGlicGF0aDoiJChTU0xfTElCKSIKICBMSU5LMzJfT0JKUz0gXAogIAkiJChJ
TlRESVIpXGJpbmQub2JqIiBcCiAgCSIkKElOVERJUilcY29sdW1uaW5mby5v
YmoiIFwKKioqKioqKioqKioqKioqCioqKiAyNzgsMjg0ICoqKioKICAgICAg
aWYgbm90IGV4aXN0ICIkKE9VVERJUikvJChOVUxMKSIgbWtkaXIgIiQoT1VU
RElSKSIKICAKICBDUFA9Y2wuZXhlCiEgQ1BQX1BST0o9L25vbG9nbyAvTVRk
IC9XMyAvR20gL0dYIC9aSSAvT2QgL0kgJChQR19JTkMpIC9EICJXSU4zMiIg
L0QgIl9ERUJVRyIgL0QgIl9XSU5ET1dTIiAvRCAiX01CQ1MiIC9EICJfVVNS
RExMIiAvRCAiUFNRTE9EQkNfRVhQT1JUUyIgL0QgIk9EQkNWRVI9MHgwMzUx
IiAvRCAiVU5JQ09ERV9TVVBQT1JUIiAvRCAiV0lOX01VTFRJVEhSRUFEX1NV
UFBPUlQiICQoQUREX0RFRklORVMpIC9GcCIkKElOVERJUilccHNxbG9kYmMu
cGNoIiAvWVggL0ZvIiQoSU5URElSKVxcIiAvRmQiJChJTlRESVIpXFwiIC9G
RCAvR1ogL2MgCiAgCiAgLmN7JChJTlRESVIpfS5vYmo6OgogICAgICQoQ1BQ
KSBAPDwKLS0tIDI4NCwyOTAgLS0tLQogICAgICBpZiBub3QgZXhpc3QgIiQo
T1VURElSKS8kKE5VTEwpIiBta2RpciAiJChPVVRESVIpIgogIAogIENQUD1j
bC5leGUKISBDUFBfUFJPSj0vbm9sb2dvIC9NVGQgL1czIC9HbSAvR1ggL1pJ
IC9PZCAvSSAiJChQR19JTkMpIiAvSSAiJChTU0xfSU5DKSIgL0QgIldJTjMy
IiAvRCAiX0RFQlVHIiAvRCAiX1dJTkRPV1MiIC9EICJfTUJDUyIgL0QgIl9V
U1JETEwiIC9EICJQU1FMT0RCQ19FWFBPUlRTIiAvRCAiT0RCQ1ZFUj0weDAz
NTEiIC9EICJVTklDT0RFX1NVUFBPUlQiIC9EICJXSU5fTVVMVElUSFJFQURf
U1VQUE9SVCIgJChBRERfREVGSU5FUykgL0ZwIiQoSU5URElSKVxwc3Fsb2Ri
Yy5wY2giIC9ZWCAvRm8iJChJTlRESVIpXFwiIC9GZCIkKElOVERJUilcXCIg
L0ZEIC9HWiAvYyAKICAKICAuY3skKElOVERJUil9Lm9iajo6CiAgICAgJChD
UFApIEA8PAoqKioqKioqKioqKioqKioKKioqIDMyMCwzMjYgKioqKgogIAkK
ICBMSU5LMzI9bGluay5leGUKICBERUZfRklMRT0gInBzcWxvZGJjX2FwaTMw
dy5kZWYiCiEgTElOSzMyX0ZMQUdTPWtlcm5lbDMyLmxpYiB1c2VyMzIubGli
IGdkaTMyLmxpYiB3aW5zcG9vbC5saWIgY29tZGxnMzIubGliIGFkdmFwaTMy
LmxpYiBzaGVsbDMyLmxpYiBvbGUzMi5saWIgb2xlYXV0MzIubGliIHV1aWQu
bGliIG9kYmMzMi5saWIgb2RiY2NwMzIubGliIHdzb2NrMzIubGliIC9ub2xv
Z28gL2RsbCAvaW5jcmVtZW50YWw6eWVzIC9wZGI6IiQoT1VURElSKVxwc3Fs
b2RiYy5wZGIiIC9kZWJ1ZyAvbWFjaGluZTpJMzg2IC9kZWY6IiQoREVGX0ZJ
TEUpIiAvb3V0OiIkKE9VVERJUilccHNxbG9kYmMzNXcuZGxsIiAvaW1wbGli
OiIkKE9VVERJUilccHNxbG9kYmMubGliIiAvcGRidHlwZTpzZXB0ICIkKFZD
MDdfREVMQVlfTE9BRCkiIC9saWJwYXRoOiIkKFBHX0xJQikiCiAgTElOSzMy
X09CSlM9IFwKICAJIiQoSU5URElSKVxiaW5kLm9iaiIgXAogIAkiJChJTlRE
SVIpXGNvbHVtbmluZm8ub2JqIiBcCi0tLSAzMjYsMzMyIC0tLS0KICAJCiAg
TElOSzMyPWxpbmsuZXhlCiAgREVGX0ZJTEU9ICJwc3Fsb2RiY19hcGkzMHcu
ZGVmIgohIExJTkszMl9GTEFHUz1rZXJuZWwzMi5saWIgdXNlcjMyLmxpYiBn
ZGkzMi5saWIgd2luc3Bvb2wubGliIGNvbWRsZzMyLmxpYiBhZHZhcGkzMi5s
aWIgc2hlbGwzMi5saWIgb2xlMzIubGliIG9sZWF1dDMyLmxpYiB1dWlkLmxp
YiBvZGJjMzIubGliIG9kYmNjcDMyLmxpYiB3c29jazMyLmxpYiAvbm9sb2dv
IC9kbGwgL2luY3JlbWVudGFsOnllcyAvcGRiOiIkKE9VVERJUilccHNxbG9k
YmMucGRiIiAvZGVidWcgL21hY2hpbmU6STM4NiAvZGVmOiIkKERFRl9GSUxF
KSIgL291dDoiJChPVVRESVIpXHBzcWxvZGJjMzV3LmRsbCIgL2ltcGxpYjoi
JChPVVRESVIpXHBzcWxvZGJjLmxpYiIgL3BkYnR5cGU6c2VwdCAiJChWQzA3
X0RFTEFZX0xPQUQpIiAvbGlicGF0aDoiJChQR19MSUIpIiAvbGlicGF0aDoi
JChTU0xfTElCKSIKICBMSU5LMzJfT0JKUz0gXAogIAkiJChJTlRESVIpXGJp
bmQub2JqIiBcCiAgCSIkKElOVERJUilcY29sdW1uaW5mby5vYmoiIFwK

------_=_NextPart_001_01C63602.71D022AD
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

------_=_NextPart_001_01C63602.71D022AD--

Re: Building the psqlODBC enhanced branch (Windows)

=20

> -----Original Message-----
> From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]=20
> Sent: 20 February 2006 15:33
> To: Dave Page
> Cc: Hiroshi Saito; psql-odbc@postgresql.org
> Subject: Re: Building the psqlODBC enhanced branch (Windows)
>=20
>=20
> Hmm, I'm using the libpq import library whose name is=20
> libpqdll.lib built=20
> via win32.mak.
> Is it inconsistent with the libpq libraries built via other ways ?

Yes - iirc, because the VC build of libpq builds a static and dynamic
library, libpqdll.lib being the dynamic one.

With anything we release now, it's good to be fully compatible with
existing builds of PostgreSQL and the pre-built binaries that it's built
around, hence I'm keen to make things work against the binary
distribution of OpenSSL and pgInstaller build of PostgreSQL.

> >however I still got the following
> >warnings:
> >
> >
>=20
> I'm using VC7 and don't see the warings. Well I seem to have removed=20
> some words
> another Hiroshi added for VC6 development. OK I've just put back the=20
> change.
> Please check it.

Yes, that clears up the warnings.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend