Re: [SQL] "No such attribute or function 'oid'"

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
Thread:
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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Gelinas Robert G 2003-06-16 17:38:42 Re: [Tiny-cobol-users] New compiler options RFC
Previous Message Andreas Pflug 2003-06-16 11:14:33 ResolveNumericParam problem

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-06-16 17:51:11 Re: casting interval to time
Previous Message Bruno Wolff III 2003-06-16 17:24:02 Re: date question