Re: [INTERFACES] iodbc interface on Unix - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] iodbc interface on Unix
Date
Msg-id 5258.903462391@sss.pgh.pa.us
Whole thread Raw
In response to Re: [INTERFACES] iodbc interface on Unix  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List pgsql-interfaces
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu> writes:
>> At this point, I can try connecting to a database, but it doesn't seem
>> to get past the first handshaking with Postgres on the wire. I'm
>> guessing that the protocol may have changed for v6.4 and those changes
>> are not in the driver I'm using?

If the iodbc code is running the older ("version 1.0") protocol, it
should still work with the current server.  A possible gotcha here
is that if the client code is compiled to send "PG_PROTOCOL_LATEST"
as the version number that it speaks, then you lose when you compile
against the current backend's include files.  You've just built a
client that claims to speak 2.0 but doesn't really.  The client really
should have its own idea of the protocol version number it uses.
(I just this weekend sent in patches to make libpq do this correctly,
BTW; so iodbc is hardly the only one to make this mistake.  If it did.)

The other possibility is that you have an iodbc that was updated to
handle the 2.0 protocol as it stood a month or two ago, but doesn't
have all of the changes quite yet.

Or, maybe the backend's support for 1.0 protocol is broken.  We do
need to check that before 6.4 is released.  I thought someone had,
however.

            regards, tom lane

pgsql-interfaces by date:

Previous
From: Andrzej Szydlo
Date:
Subject: ODBC, Delphi and BLOBs (images)
Next
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] iodbc interface on Unix