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

Re: change to error result in SQLStatistics

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: change to error result in SQLStatistics
Date: 2004-10-05 14:44:07
Message-ID: A8535F8D62F3644997E91F4F66E341FCA137A1@exchange.sandvine.com (view raw or flat)
Thread:
Lists: pgsql-odbc
yes, I'll do the patch, I should have it done this week.

scot.


-----Original Message-----
From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Sent: Tuesday, October 05, 2004 10:28 AM
To: Scot Loach; pgsql-odbc(at)postgresql(dot)org
Subject: RE: [ODBC] change to error result in SQLStatistics


 

> -----Original Message-----
> From: Scot Loach [mailto:sloach(at)sandvine(dot)com] 
> Sent: 05 October 2004 15:16
> To: Dave Page; pgsql-odbc(at)postgresql(dot)org
> Subject: RE: [ODBC] change to error result in SQLStatistics
> 
> I agree with your suggestion to check that the table exists 
> at the beginning of PGAPI_Statistics().
> 
> What would you suggest as a query to do this?
> 
> for example - I can do the following query - "select relname 
> from pg_class where relname = 'elem_portstats';"
> 
> and do an Fetch, and return an error if there are no results.

Well, we'd need some schema filtering in there, along the same lines as
is already there for the main part of the function (I've not entirely
deciphered the logic in there yet), but that's essentially it. Are you
volunterring to give it a go? :-)

Regards, Dave.

pgsql-odbc by date

Next:From: Dave PageDate: 2004-10-05 14:48:32
Subject: Re: change to error result in SQLStatistics
Previous:From: Sandro Yaqub YusufDate: 2004-10-05 14:35:11
Subject: Thanks - Part One - Re: Executing SP in VB6

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