Skip site navigation (1) Skip section navigation (2)

Re: psqlODBC 09.00.0310 and oids

From: Nirgal Vourgère <jvourger(at)greenpeace(dot)org>
To: Hiroshi Saito <hiroshi(at)winpg(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlODBC 09.00.0310 and oids
Date: 2011-07-12 09:26:27
Message-ID: 201107121456.30294.jvourger@greenpeace.org (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-odbc
On Friday 08 July 2011 21:08:21 Hiroshi Saito wrote:
> Changes and updates in the new release include:
> 5.) Handle *with or without oids* correctly.

Thank you very much.
However, the behaviour is still no exactly what I expected:

I have a legacy excel 97 database, poorly designed, with about 100 tables, 1000 queries, complex forms... You get the picture.
I used a recent mdbtools snapshot from git to convert the database to postgres (index, default values, constaints, this rocks!).
However, I had a lot of tables without a primary keys.
What I did is adding oids for these tables, and created a primary key (on oid).

Now, I still have some legacy code from access I'd like to use.
I changed the access tables to psql linked tables, and I'm opening the connection with that:
ODBC;CA=r;A6=;A7=100;A8=4096;B0=255;B1=8190;B9=0;BI=0;C2=dd_;CX=1b102bb;A1=8.4;DSN=india;SERVER=10.10.10.146;DATABASE=india;PORT=5432;UID=jvourger;PASSWORD=xxxxxxxx
(This is CX with BIT_SHOWOIDCOLUMN)
But when open these tables with a primary key on oid, I don't see the oid column and I can't append data.

I also tried CX=1d102bb (BIT_FAKEOIDINDEX). Same results.

Does anyone has any idea about what is going on?
Is that an excel problem? Or is there some change I could make in psqlodc to have these linked tables work with legacy access modules?

-- 
- - Nirgal Vourgère ☮ GP France ☮ tel:+33.180969724
-   xmpp:nirgal(at)nirgal(dot)com ☮ gpg 0x4760b41db292ab13 ☮ skype:nirgal_v
    nirgal.com:qotd ☮ Be the change you want to see in the world -- Gandhi

In response to

Responses

pgsql-announce by date

Next:From: Josh BerkusDate: 2011-07-12 23:27:36
Subject: PostgreSQL 9.1 Beta 3 Released
Previous:From: Hiroshi SaitoDate: 2011-07-08 15:38:21
Subject: psqlODBC 09.00.0310 Released

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2011-07-13 13:28:07
Subject: Re: psqlODBC 09.00.0310 and oids
Previous:From: Hiroshi SaitoDate: 2011-07-09 14:20:50
Subject: Re: Compiling 09.00.0300 on OS X Snow Leopard

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group