Received: from www.kpi.com.au (www.kpi.com.au [203.31.83.86])
	by hub.org (8.9.3/8.9.3) with ESMTP id SAA09783
	for <pgsql-interfaces@postgresql.org>;
	Wed, 1 Mar 2000 18:51:44 -0500 (EST)
	(envelope-from shevlandj@kpi.com.au)
Received: from elite (ws00.kpi.com.au [203.39.132.213])
	by www.kpi.com.au (8.9.3/8.9.3) with ESMTP id KAA46085
	for <pgsql-interfaces@postgresql.org>;
	Thu, 2 Mar 2000 10:51:25 +1100 (EST)
	(envelope-from shevlandj@kpi.com.au)
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>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

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