Received: from mail.rdc1.md.home.com (imail@ha1.rdc1.md.home.com [24.2.2.66])
	by hub.org (8.9.3/8.9.3) with ESMTP id WAA32446
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 1 Mar 2000 22:45:18 -0500 (EST)
	(envelope-from byron.nikolaidis@home.com)
Received: from home.com ([24.4.141.52]) by mail.rdc1.md.home.com
	(InterMail v4.01.01.00 201-229-111) with ESMTP
	id <20000302034513.MOO20034.mail.rdc1.md.home.com@home.com>;
	Wed, 1 Mar 2000 19:45:13 -0800
Message-ID: <38BDE395.5D8A01C2@home.com>
Date: Wed, 01 Mar 2000 22:44:21 -0500
From: Byron Nikolaidis <byron.nikolaidis@home.com>
Organization: @Home Network
X-Mailer: Mozilla 4.5 [en]C-AtHome0405  (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Joe Shevland <shevlandj@kpi.com.au>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Access, Views and the OID
References: <NDBBLJFAELMHMDPDFAGLMELGCAAA.shevlandj@kpi.com.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



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