From: Byron Nikolaidis <byronn@solipsys.com>
To: Dave Page <dpage@vale-housing.co.uk>
Cc: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] ODBC: OID column in views
Date: Tue, 29 Jun 1999 10:02:12 -0400
Message-ID: <3778D1E4.FF451578@solipsys.com> (raw)
References: <B9FE686F5C26D311AC22006097BCD3D65EFC@woody.vale-housing.co.uk>
Dave Page wrote:
> I've recently come across a couple of minor problems(?) in the ODBC driver:
>
> 1) When querying a view eg:
>
> SELECT * FROM pg_tables;
>
> the driver will always attempt (and fail) to retrieve the oid column thus
> returning an ODBC call failed error. This occurs whether the 'Show OID
> Column' is selected or not. I can see the obvious overhead in checking
> whether or not a query is on a view or table - is the current behaviour the
> best solution or is there another way around this (other than specifying
> column names in queries)?
>
I'm not sure what you mean by "the driver will always attempt to retrieve the oid
column"... What is the driver doing? If it is sending another query, could you show
me exactly what because its been a while since I looked at the code.
>
> 2) Under OID options, if you uncheck 'Show Column', the 'Fake Index' option
> will correctly be greyed out. If it is ticked when it is greyed though, the
> driver will still connect with: showoid='0',fakeoidindex='1'. Can this cause
> any problems?
>
I dont think so, but I'm not 100% sure.
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@solipsys.com, dpage@vale-housing.co.uk
Subject: Re: [INTERFACES] ODBC: OID column in views
In-Reply-To: <3778D1E4.FF451578@solipsys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox