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

Re: psqlODBC 08.00.0102 available for download

From: "Scot Loach" <sloach(at)sandvine(dot)com>
To: "Anoop Kumar" <anoopk(at)pervasive-postgres(dot)com>,"Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: psqlODBC 08.00.0102 available for download
Date: 2005-08-12 13:58:52
Message-ID: 71837C040963F748B9B94E123A289678664B9C@mailserver.sandvine.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Thanks Anoop.
Actually I think the old driver always returned 0 for select statements too, so the behavior should now be consistent.

scot.


-----Original Message-----
From: Anoop Kumar [mailto:anoopk(at)pervasive-postgres(dot)com]
Sent: Friday, August 12, 2005 2:11 AM
To: Dave Page; Scot Loach; pgsql-odbc(at)postgresql(dot)org
Subject: RE: [ODBC] psqlODBC 08.00.0102 available for download


Hi Scot,

I am attaching a patch to solve the SQLRowCount() issue you have faced.
This should enable you to get the number of rows affected by an
INSERT/DELETE or UPDATE operation.

The old odbc driver returned the number of rows after a select
statement. Now the libpq enabled version returns a zero. 

Regards

Anoop


> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-
> owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: Thursday, August 11, 2005 1:59 PM
> To: Scot Loach; pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] psqlODBC 08.00.0102 available for download
> 
> 
> 
> > -----Original Message-----
> > From: Scot Loach [mailto:sloach(at)sandvine(dot)com]
> > Sent: 11 August 2005 03:56
> > To: Dave Page; pgsql-odbc(at)postgresql(dot)org
> > Subject: RE: [ODBC] psqlODBC 08.00.0102 available for download
> >
> > I finally got around to giving the new driver a try.
> >
> > There's one major problem I'm running into.  Specifically,
> > the SQLRowCount() function doesn't work with the libpq
implementation.
> >
> > Can anyone comment on this?
> 
> I'll investigate....
> 
> /D
> 
> ---------------------------(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

pgsql-odbc by date

Next:From: Hans-Jürgen SchönigDate: 2005-08-12 17:29:07
Subject: Re: Implementing IPv6 ...
Previous:From: Dave PageDate: 2005-08-12 13:55:37
Subject: Re: New libpq driver snapshot

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