Re: change to error result in SQLStatistics - Mailing list pgsql-odbc

From Scot Loach
Subject Re: change to error result in SQLStatistics
Date
Msg-id A8535F8D62F3644997E91F4F66E341FCA137A1@exchange.sandvine.com
Whole thread Raw
In response to change to error result in SQLStatistics  ("Scot Loach" <sloach@sandvine.com>)
List pgsql-odbc
yes, I'll do the patch, I should have it done this week.

scot.


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




> -----Original Message-----
> From: Scot Loach [mailto:sloach@sandvine.com]
> Sent: 05 October 2004 15:16
> To: Dave Page; pgsql-odbc@postgresql.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:

Previous
From: "Sandro Yaqub Yusuf"
Date:
Subject: Thanks - Part One - Re: Executing SP in VB6
Next
From: "Dave Page"
Date:
Subject: Re: change to error result in SQLStatistics