I have found the following incompatibilities in 8.02.00.02 development
snapshot compared with last stable version (8.01.02.00)
1. 8.02.00.02 returns multiple record set (2 tables) for the following
string. First table in result set contains single column drop_table
SELECT drop_table('tempDOK') ;
CREATE TEMP TABLE tempDOK AS SELECT * FROM dok WHERE doktyyp=?ko.liik
AND (?ko.option1=0 or dok.tasumata<>0) AND
(?ko.option2=0 or dok.taidetud) AND true ORDER BY dokumnr LIMIT
100 OFFSET 100;SELECT * FROM tempDOK
How to force new driver to return single record set for this query?
2. C:\Documents and Settings\Administrator\Application
Data\postgresql\pgpass.conf file is not used for default passwords.
How to force driver to use pgpass.conf file for passwords like used by
pgAdmin and other libpq applications ?
3. My application uses hard-coded driver name
DRIVER={PostgreSQL Unicode}
and thus does not work with new driver. How to force new driver to be
invoked by connection string DRIVER={PostgreSQL Unicode} ?
Windows XP SP2
Postgres 8.1
Microsoft Visual FoxPro 9.0
Andrus.