Re: row count with libpq driver - Mailing list pgsql-odbc

From Scot Loach
Subject Re: row count with libpq driver
Date
Msg-id 71837C040963F748B9B94E123A2896785A1086@mailserver.sandvine.com
Whole thread Raw
In response to row count with libpq driver  ("Scot Loach" <sloach@sandvine.com>)
List pgsql-odbc
A patch for this is attached, please review.

scot.


-----Original Message-----
From:    Dave Page [mailto:dpage@vale-housing.co.uk]
Sent:    Fri 9/9/2005 8:02 AM
To:    Scot Loach; pgsql-odbc@postgresql.org
Cc:
Subject:    RE: [ODBC] row count with libpq driver


> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Scot Loach
> Sent: 09 September 2005 12:52
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] row count with libpq driver
>
> Previously you guys made some fixes to the odbc driver
> dealing with row counts.
> I have noticed that the old driver seems to return the
> correct row count for SELECT statements, at least in some cases.
> The new driver does not; it only works for INSERT and UPDATE
> statements.
> Is this behavior intentional, is it possible to fix this?

Technically that is as per spec
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/ht
m/odbcsqlrowcount.asp, however the spec does allow the row count from
selects to be returned if the driver wants. Feel free to submit a patch
(I'm swamped right now :-( ).

Regards, Dave




Attachment

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: PATCH: SQLTables and case sensitivity
Next
From: "Dave Page"
Date:
Subject: Re: PATCH: SQLTables and case sensitivity