Postgres Pro
Downloads
Home   >   mailing lists

Thread: Recognize unique indexes

Recognize unique indexes

From
"Tomas Fulajtar"
Date:
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?

With regards




---------------------------------------------
  Ing. Tomas Fulajtar
  MORAVIAPRESS, a.s.
  U pony 3061
  690 02 Breclav
  tel.: 0627/305 216

  E-mail: tomas.fulajtar@moraviapress.cz
  WWW:    www.moraviapress.cz
  ---------------------------------------------
  P.S.:Please use pure ASCII or ISO-8859-2 code

Re: Recognize unique indexes

From
Hiroshi Inoue
Date:
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

Re: Recognize unique indexes

From
"Tomas Fulajtar"
Date:
> 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