Re: 8.02.00.02 driver incompatibilities

Andrus wrote:
> 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?

What kind of tool are you using ?
Doesn't your tool have any way to skip the first recordset ?

> 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 ?

Select an SSL Mode other than *disable* e.g. *allow*.

> 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} ?

regards,
Hiroshi Inoue