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

Re: psqlODBC 08.00.0102 available for download

From: "Anoop Kumar" <anoopk(at)pervasive-postgres(dot)com>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>,"Scot Loach" <sloach(at)sandvine(dot)com>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: psqlODBC 08.00.0102 available for download
Date: 2005-08-12 06:10:57
Message-ID: B4AF8C04F762D246A1E38EC5DFAEFC0B0379C0@blrmail2.aus.pervasive.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

Attachment: sqlrowcount_libpq.patch
Description: application/octet-stream (1.2 KB)

pgsql-odbc by date

Next:From: Dave PageDate: 2005-08-12 10:03:36
Subject: Re: psqlODBC 08.00.0102 available for download
Previous:From: Bobby BrewsterDate: 2005-08-12 03:19:28
Subject: Re: HELP: Unrecognized key passed to SQLGetInfo30(#209)

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