Thread: Trouble with slow ODBC query via Access

I've replaced the backend of that large nasty Access db with PostgreSQL 7.3. It seems to be
workin quite well except one table refuses to work well with an indexed field. Its a simple integer
with a unique index - other tables have them too and seem to work. However, when I do a find on it
for this particular table it insists on running through every record in the table and manually searching
for the value rather than a simple select for the value.

Is this possibly something that the ODBC drivers address? I'm using PostgreSQL+Unicode(Beta)
7.02.00.04. If not - does anyone know how to execute a simple pass thru SQL statement via
Access 2002?

    many thanx,

        Ben Scherrey

Benjamin Scherrey wrote:
>
> I've replaced the backend of that large nasty Access db with PostgreSQL 7.3. It seems to be
> workin quite well except one table refuses to work well with an indexed field. Its a simple integer
> with a unique index - other tables have them too and seem to work. However, when I do a find on it
> for this particular table it insists on running through every record in the table and manually searching
> for the value rather than a simple select for the value.

Could you tell me the definition of the table ?

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/