I have installed the Whitebox version of Red Hat 3.0 ES with PostgreSQL version 7.4.3. I am using a Linux application that uses an ODBC connection on the Linux machine. There appear to be at least three PostGreSQL ODBC drivers available in the /usr/lib directory: psqlodbc.so, libodbcpsql.so.1, and libodbcpsql.so.2. When my application connects to the driver, it queries the driver name and version. With the psqlodbc.so, the name is PostgreSQL Legacy, and the version is 07.03.0100. With libodbc.so.1 driver, the name is PostgreSQL and the version is 6.40.0007. With libodbc.so.2, the name is PostgreSQL and the version is 07.01.0003.
From a prior posting, it appears the the name PostgreSQL Legacy is used for ODBC 2.5 drivers, and the new ODBC 3.0 drivers use the name PostgreSQL. So it would appear that the libodbcpsql.so.2 is the latest driver. Is this correct? If not, which is the current / latest stable driver? Thanks.