| From: | Shachar Shemesh <shachar(at)lingnu(dot)com> |
|---|---|
| To: | Secrétariat <ets(at)rolland-fr(dot)com> |
| Cc: | ODBC PostgreSQL <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: OIDS column required with ODBC ? |
| Date: | 2004-09-27 08:23:26 |
| Message-ID: | 4157CDFE.3030807@lingnu.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Secrétariat wrote:
> I use the Open Method from ADO in MS Visual-Basic 6.0 ...
> Is there anybody who can explain to me why I can't open tables without
> OIDS ?
>
> Thanks.
>
> Luc
The ODBC driver is emulating updateable cursors by adding the xid and
oid to each query. It can then identify each row in the result, and
update it if requested. When you open a table that doesn't have oid,
this open fails.
To work around this problem, you need to open your rows in a
non-updateable mode, which will make ODBC not add the requirement for
oid in the table, and solve the problem.
Shachar
--
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shachar Shemesh | 2004-09-27 08:24:59 | Re: Hello |
| Previous Message | Gary Doades | 2004-09-27 06:37:54 | Re: odbc with PostgreSQL 8.0 & Delphi |