Access - ODBC - index strange bug

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Access - ODBC - index strange bug
Date: 2004-04-06 17:51:43
Message-ID: 6C0CF58A187DA5479245E0830AF84F4208029B@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

I experience a strange bug when inserting a row into a table in which I
have recently added a few indexes.
This table is linked to a MS Access database through ODBC (Latest known
snapshot from Hiroshi).

When I insert a row, the serial id and different other columns are
completely mixed up. Onscreen, the inserted line inherits some values
from past lines (that have similar values), even the primary key! Things
get back to normal when I do a complete requery of the table, all values
are correct, as they should always have been.

Everything works fine if I delete the indexes.

I made a try with PG 7.3.4 and 7.4.2, same problem.

I have tried playing with the driver options, especially the one related
to indexes, without success.

Did anyone have the same problem already?

Browse pgsql-odbc by date

  From Date Subject
Next Message Philippe Lang 2004-04-07 06:39:48 Re: Access - ODBC - index strange bug
Previous Message Rob Caulfield 2004-04-06 17:27:38 PGSQL ODBC Install problems under windows