From: | "Joe Shevland" <shevlandj(at)kpi(dot)com(dot)au> |
---|---|
To: | "Byron Nikolaidis" <byron(dot)nikolaidis(at)home(dot)com> |
Cc: | <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | RE: [INTERFACES] Access, Views and the OID |
Date: | 2000-03-02 23:15:27 |
Message-ID: | NDBBLJFAELMHMDPDFAGLCELOCAAA.shevlandj@kpi.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
<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(at)postgreSQL(dot)org
[mailto:owner-pgsql-interfaces(at)postgreSQL(dot)org]On Behalf Of Byron
Nikolaidis
Sent: Wednesday, 1 March 2000 7:44 PM
To: Joe Shevland
Cc: pgsql-interfaces(at)postgreSQL(dot)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(at)kpi(dot)com(dot)au
>
> ************
Sounds like an old bug.
Do you have the latest version of the driver (v.06.40.0009)?
Byron
************
From | Date | Subject | |
---|---|---|---|
Next Message | bweaver | 2000-03-03 03:44:20 | Quick perl question |
Previous Message | Ken J. Wright | 2000-03-02 20:26:20 | Re: [INTERFACES] Windows Interface? |