| Lists: | pgsql-odbcpgsql-sql |
|---|
| From: | javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | "No such attribute or function 'oid'" |
| Date: | 2003-06-13 11:59:50 |
| Message-ID: | 200306131146.h5DBkQI06240@natura.cebas.csic.es |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc pgsql-sql |
Hi;
I'm using ODBC driver for windows, because I use Excel (Microsoft) to work
with data. When I try to get data from a Postgres table there is no problem;
but when I try to acces a view I get the mesage:
"No such attribute or function 'oid'"
When I try to access views from ACCESS2000 there is no problem
What is the cause of this? Can I resolve it?
Thanks and regards
Javier
| From: | Tomasz Myrta <jasiek(at)klaster(dot)net> |
|---|---|
| To: | javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: [SQL] "No such attribute or function 'oid'" |
| Date: | 2003-06-16 17:28:50 |
| Message-ID: | 3EEDFE52.40002@klaster.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc pgsql-sql |
Dnia 2003-06-13 13:59, Uz.ytkownik javier garcia - CEBAS napisa?:
> Hi;
> I'm using ODBC driver for windows, because I use Excel (Microsoft) to work
> with data. When I try to get data from a Postgres table there is no problem;
> but when I try to acces a view I get the mesage:
> "No such attribute or function 'oid'"
>
> When I try to access views from ACCESS2000 there is no problem
> What is the cause of this? Can I resolve it?
>
> Thanks and regards
>
> Javier
"oid" is a table field. If you create view and you don't expose oid from
any table - you loose access to this field.
Regards,
Tomasz Myrta