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

Re: row count with libpq driver

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Scot Loach" <sloach(at)sandvine(dot)com>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: row count with libpq driver
Date: 2005-09-16 16:05:48
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC2CE9@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Scot,

Unfortunately I've been seeing some unexplained errors with some
Microsoft ADO based apps since applying this patch, so I've backed it
out for now. Unfortunately, ADO doesn't give any useful error messages.

I'm not entirely sure what's wrong - can you look at it please? I'm
still swamped at the moment :-(

Regards, Dave

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: 15 September 2005 09:12
> To: Scot Loach; pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] row count with libpq driver
> 
>  
> 
> > -----Original Message-----
> > From: Scot Loach [mailto:sloach(at)sandvine(dot)com] 
> > Sent: 15 September 2005 04:02
> > To: Dave Page; pgsql-odbc(at)postgresql(dot)org
> > Subject: RE: [ODBC] row count with libpq driver
> > 
> > A patch for this is attached, please review.
> 
> Thanks Scot - patch applied with a couple of minor fixes - 
> specifically
> 
> +#ifndef USE_LIBPQ
> +                        if (res->recent_processed_row_count = 0 &&
> res->ntuples > 0)
> +                        {
> +                            *pcrow = res->ntuples;
> +                            return SQL_SUCCESS;
> +                        }
> +#endif
> 
> Was changed to
> 
> +#ifdef USE_LIBPQ
> +                        if (res->recent_processed_row_count == 0 &&
> res->ntuples > 0)
> +                        {
> +                            *pcrow = res->ntuples;
> +                            return SQL_SUCCESS;
> +                        }
> +#endif
> 
> Note the '#ifdef', and '== 0'
> 
> Regards, Dave
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

pgsql-odbc by date

Next:From: Scot LoachDate: 2005-09-16 17:11:41
Subject: Re: row count with libpq driver
Previous:From: Dave PageDate: 2005-09-16 07:51:07
Subject: Re: ODBC Driver on Windows 64 bit

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