From: Joe Shevland <shevlandj@kpi.com.au>
To: pgsql-interfaces@postgresql.org
Subject: Access, Views and the OID
Date: Thu, 2 Mar 2000 10:52:34 -0800
Message-ID: <NDBBLJFAELMHMDPDFAGLMELGCAAA.shevlandj@kpi.com.au> (raw)
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
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: shevlandj@kpi.com.au
Subject: Re: Access, Views and the OID
In-Reply-To: <NDBBLJFAELMHMDPDFAGLMELGCAAA.shevlandj@kpi.com.au>
* 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