RE: [INTERFACES] ODBC: OID column in views

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Byron Nikolaidis'" <byronn(at)solipsys(dot)com>
Cc: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: [INTERFACES] ODBC: OID column in views
Date: 1999-06-29 15:05:00
Message-ID: B9FE686F5C26D311AC22006097BCD3D65EFE@woody.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> -----Original Message-----
> From: owner-pgsql-interfaces(at)postgreSQL(dot)org
> [mailto:owner-pgsql-interfaces(at)postgreSQL(dot)org]On Behalf Of Byron
> Nikolaidis
> Sent: 29 June 1999 14:02
> To: Dave Page
> Cc: 'pgsql-interfaces(at)postgresql(dot)org'
> Subject: Re: [INTERFACES] ODBC: OID column in views
>
>
>
>
> 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.

The commlog shows the following when the query 'SELECT * FROM pg_tables;' is
executed via DAO (I've just thought though, would it be the driver or
perhaps DAO that is expanding the wildcard?):

conn=175915324, query='SELECT "oid" ,"tablename" ,"tableowner" ,"hasindexes"
,"hasrules" ,"hastriggers" FROM "pg_tables" '
ERROR from backend during send_query: 'ERROR: system column oid not
available - pg_tables is a view'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'

Presumably if it's DAO that's expanding the wildcard, it would still be the
driver reporting the existance of the oid column?

Regards,

Dave.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Byron Nikolaidis 1999-06-29 16:41:23 Re: [INTERFACES] ODBC: OID column in views
Previous Message Stan Brown 1999-06-29 14:35:23 ODBC info?