8.02.00.02 driver incompatibilities

From: "Andrus" <eetasoft(at)online(dot)ee>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: 8.02.00.02 driver incompatibilities
Date: 2006-06-10 20:08:44
Message-ID: 001301c68cca$318107e0$0406eb50@acer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Elvis E. Henríquez 2006-06-11 20:36:31 Retrieving Binary Data in VB6
Previous Message noreply 2006-06-10 15:36:40 [ psqlodbc-Bugs-1000661 ] Visio does not see ODBC DSNs created with 8.02 or 8.01 drivers