Re: change to error result in SQLStatistics

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.