Another difference is the "state" that is returned from SQLGetDiagRec when a connection is lost during a query. This used to return 08S01. It now returns HY000. From the documentation it would appear that 08S01 is the correct return code in this case. I'm guessing the error codes are not implemented in the libpq version of the driver yet.

Also, SQLGetConnectAttr with SQL_ATTR_CONNECTION_DEAD doesn't seem to work anymore.



-----Original Message-----
From: pgsql-odbc-owner@postgresql.org on behalf of Scot Loach
Sent: Thu 8/18/2005 10:03 AM
To: Anoop Kumar; pgsql-odbc@postgresql.org
Cc:
Subject: Re: [ODBC] changed behavior in libpq odbc driver
OS is FreeBSD 5.4, but I really don't think this matters.
PostgreSQL 7.4.6
old psqlodbc is version 07.03.0200, but it has various updates applied to it.
new psqlodbc is the latest from CVS as of about a week ago.


-----Original Message-----
From: Anoop Kumar [mailto:anoopk@pervasive-postgres.com]
Sent: Thursday, August 18, 2005 6:23 AM
To: Scot Loach; pgsql-odbc@postgresql.org
Subject: RE: [ODBC] changed behavior in libpq odbc driver


Hi Scot,

Can you provide the following details?
1. The psqlodbc (socket) version you used
2. PostgreSQL version
3. OS

Regards

Anoop

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org [mailtogsql-odbc-
> owner@postgresql.org] On Behalf Of Scot Loach
> Sent: Thursday, August 18, 2005 7:18 AM
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] changed behavior in libpq odbc driver
>
> I'm not sure whether the old driver or the new one is correct.
>
> When executing an UPDATE query with a WHERE clause, if the WHERE
clause
> does not match any rows, the old driver returns SQL_NO_DATA. The new
> driver returns SQL_SUCCESS.
>
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match