From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: Joe Shevland <shevlandj@kpi.com.au>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Access, Views and the OID
Date: Wed, 01 Mar 2000 22:44:21 -0500
Message-ID: <38BDE395.5D8A01C2@home.com> (raw)
References: <NDBBLJFAELMHMDPDFAGLMELGCAAA.shevlandj@kpi.com.au>
Joe Shevland wrote:
>
> Hi,
>
> I'm getting an error when using linked tables within Access, using ODBC to
> connect to a remote Postgres 6.5.2 database:
>
> 'ERROR: system column oid not available - view_emp_locations is a view (#1)'
>
> I've got the OID checkbox and fake-index checkbox ticked, as I use pgadmin
> to do the real work behind the scenes.
>
> Any pointers for how to get views working in this fashion?
>
> Otherwise I'll have to use a braindead-Access query which probably wants to
> pull all the data across the network first
> to just look at one row...
>
> Cheers,
> Joe
>
> ---
> Joe Shevland
> Principal Consultant
> KPI Logistics Pty Ltd
> http://www.kpi.com.au
> mailto:shevlandj@kpi.com.au
>
> ************
Sounds like an old bug.
Do you have the latest version of the driver (v.06.40.0009)?
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: byron.nikolaidis@home.com, shevlandj@kpi.com.au
Subject: Re: [INTERFACES] Access, Views and the OID
In-Reply-To: <38BDE395.5D8A01C2@home.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