Skip site navigation (1) Skip section navigation (2)

Re: row count with libpq driver

From: "Scot Loach" <sloach(at)sandvine(dot)com>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: row count with libpq driver
Date: 2005-09-15 03:02:15
Message-ID: 71837C040963F748B9B94E123A2896785A1086@mailserver.sandvine.com (view raw or flat)
Thread:
Lists: pgsql-odbc
A patch for this is attached, please review.

scot.


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

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Scot Loach
> Sent: 09 September 2005 12:52
> To: pgsql-odbc(at)postgresql(dot)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: rowcount.patch
Description: application/octet-stream (1.5 KB)

pgsql-odbc by date

Next:From: Dave PageDate: 2005-09-15 07:46:02
Subject: Re: PATCH: SQLTables and case sensitivity
Previous:From: Dave PageDate: 2005-09-14 20:41:56
Subject: Re: PATCH: SQLTables and case sensitivity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group