Re: change to error result in SQLStatistics

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: change to error result in SQLStatistics
Date: 2004-10-05 14:28:27
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E430693A@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----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.

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2004-10-05 14:32:01 Re: Access and PG ODBC problem
Previous Message anthony.caduto 2004-10-05 14:18:32 Re: Access and PG ODBC problem