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

Re: Recognize unique indexes

From: "Tomas Fulajtar" <tomas(dot)fulajtar(at)moraviapress(dot)cz>
To: pgsql-odbc(at)postgresql(dot)org
Cc: Inoue(at)tpf(dot)co(dot)jp
Subject: Re: Recognize unique indexes
Date: 2001-04-06 06:52:03
Message-ID: 3ACD83B3.31436.9AAFF27@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
> Tomas Fulajtar wrote:
> > 
> > Hello,
> > I'am  using MSAccess 97 with Postgres 7.0x as
> > backend. ODBC driver parameter <Recognize unique
> > indexes> is set to on. When i link table as an ODBC,
> > access manager ask me for unique index for each table.
> > Why don't it recognize my table's primary or foreign keys
> > ? I must set this manualy. I want to link table in VBA
> > code dynamicaly, but for this reason it is impossible
> > (when i do'nt set any field as index, i can't update any
> > table). What solution is for it?
> > 
> Which version of psqlodbc driver are you using ?
> regards,
> Hiroshi Inoue

I solved this problem by upgrading driver to version 
7.01.0004. Everything is ok now, each index is 
recognized correctly. Only when I link tables without any 
unique index i must set index manually to oid. 
 At end I have a question -  what is better for performance 
- set recognize unique indexes to on (this require tables 
with primary keys ) or set to on fake index. I am using 
tables with multi column primary keys.

Thanks for any answer

Tomas Fulajtar

In response to

pgsql-odbc by date

Next:From: TamsinDate: 2001-04-06 15:38:22
Subject: access #s_c_h#
Previous:From: Hiroshi InoueDate: 2001-04-06 06:10:37
Subject: Re: MS Access help with boolean values

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