pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] Access, Views and the OID
3+ messages / 2 participants
[nested] [flat]
* Access, Views and the OID
@ 2000-03-02 18:52 Joe Shevland <shevlandj@kpi.com.au>
2000-03-02 03:44 ` Re: [INTERFACES] Access, Views and the OID Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 1 reply; 3+ messages in thread
From: Joe Shevland @ 2000-03-02 18:52 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Access, Views and the OID
2000-03-02 18:52 Access, Views and the OID Joe Shevland <shevlandj@kpi.com.au>
@ 2000-03-02 03:44 ` Byron Nikolaidis <byron.nikolaidis@home.com>
2000-03-02 23:15 ` RE: [INTERFACES] Access, Views and the OID Joe Shevland <shevlandj@kpi.com.au>
0 siblings, 1 reply; 3+ messages in thread
From: Byron Nikolaidis @ 2000-03-02 03:44 UTC (permalink / raw)
To: Joe Shevland <shevlandj@kpi.com.au>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: [INTERFACES] Access, Views and the OID
2000-03-02 18:52 Access, Views and the OID Joe Shevland <shevlandj@kpi.com.au>
2000-03-02 03:44 ` Re: [INTERFACES] Access, Views and the OID Byron Nikolaidis <byron.nikolaidis@home.com>
@ 2000-03-02 23:15 ` Joe Shevland <shevlandj@kpi.com.au>
0 siblings, 0 replies; 3+ messages in thread
From: Joe Shevland @ 2000-03-02 23:15 UTC (permalink / raw)
To: Byron Nikolaidis <byron.nikolaidis@home.com>; +Cc: 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@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
************
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-03-02 23:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-03-02 18:52 Access, Views and the OID Joe Shevland <shevlandj@kpi.com.au>
2000-03-02 03:44 ` Byron Nikolaidis <byron.nikolaidis@home.com>
2000-03-02 23:15 ` Joe Shevland <shevlandj@kpi.com.au>
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