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

From Dave Page
Subject Re: change to error result in SQLStatistics
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E430693A@ratbert.vale-housing.co.uk
Whole thread Raw
In response to change to error result in SQLStatistics  ("Scot Loach" <sloach@sandvine.com>)
List pgsql-odbc

> -----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: anthony.caduto@micorp.com
Date:
Subject: Re: Access and PG ODBC problem
Next
From: "Dave Page"
Date:
Subject: Re: Access and PG ODBC problem