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 XAA35305
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 1 Mar 2000 23:14:42 -0500 (EST)
	(envelope-from shevlandj@kpi.com.au)
Received: from elite (pA15.hbt.southcom.com.au [203.60.23.22])
	by www.kpi.com.au (8.9.3/8.9.3) with SMTP id PAA46609;
	Thu, 2 Mar 2000 15:14:19 +1100 (EST)
	(envelope-from shevlandj@kpi.com.au)
From: "Joe Shevland" <shevlandj@kpi.com.au>
To: "Byron Nikolaidis" <byron.nikolaidis@home.com>
Cc: <pgsql-interfaces@postgreSQL.org>
Subject: RE: [INTERFACES] Access, Views and the OID
Date: Thu, 2 Mar 2000 15:15:27 -0800
Message-ID: <NDBBLJFAELMHMDPDFAGLCELOCAAA.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)
X-Mimeole: Produced By Microsoft MimeOLE V5.00.2919.6600
In-reply-to: <38BDE395.5D8A01C2@home.com>
Importance: Normal

<sound of someone booting themselves>

Thanks very much for that, I've got .0006
so I'll upgrade. I thought I had a pretty recent
one, but anyway, mustn't be.

Thanks,
Joe

-----Original Message-----
From: owner-pgsql-interfaces@postgreSQL.org
[mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Byron
Nikolaidis
Sent: Wednesday, 1 March 2000 7:44 PM
To: Joe Shevland
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Access, Views and the OID




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

************