From: Hannu Krosing <hannu@trust.ee>
To: David Hartwig <daveh@insightdist.com>
Cc: Jose' Soares Da Silva <sferac@bo.nettuno.it>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Cc: hackers postgres <pgsql-hackers@postgreSQL.org>
Subject: Re: [INTERFACES] ODBC is slow with M$-Access Report
Date: Tue, 02 Jun 1998 20:11:41 +0300
Message-ID: <3574324D.8DE61386@trust.ee> (raw)
References: <Pine.LNX.3.96.980601173507.10343A-100000@proxy.bazzanese.com>
<35741E93.91DE9C4F@insightdist.com>
David Hartwig wrote:
>
> > 1. The PostgreSQL doesn't use the index with "OR" operator and
> > so is not possible to define a multiple key to use with M$-Access
> > and we need to retreat using OID as primary keys (thanks to Byron
> > Nikolaidis and David Hartwig of insightdist.com that are doing a
> > really great job with ODBC driver), but with the obvious consequences.
>
> I am currently working on a solution as time will allow. Hopefully part of 6.4
>
Will this solution be in ODBC driver (rewrite ORs to UNION) or in
the backend (fix the optimiser)?
------
Hannu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hannu@trust.ee, daveh@insightdist.com, sferac@bo.nettuno.it, pgsql-hackers@postgreSQL.org
Subject: Re: [INTERFACES] ODBC is slow with M$-Access Report
In-Reply-To: <3574324D.8DE61386@trust.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox