| From: | Hannu Krosing <hannu(at)trust(dot)ee> |
|---|---|
| To: | David Hartwig <daveh(at)insightdist(dot)com> |
| Cc: | "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>, PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org>, hackers postgres <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [INTERFACES] ODBC is slow with M$-Access Report |
| Date: | 1998-06-02 17:11:41 |
| Message-ID: | 3574324D.8DE61386@trust.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-06-02 17:26:00 | Re: [HACKERS] An easier way to upgrade (Was: Lots 'o patches) |
| Previous Message | Bruce Momjian | 1998-06-02 17:08:27 | Re: [HACKERS] An easier way to upgrade (Was: Lots 'o patches) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Bosinius | 1998-06-02 17:33:54 | RE: [INTERFACES] whoops: VB RDO works just fine with new odbc dri ver.... |
| Previous Message | The Hermit Hacker | 1998-06-02 16:34:40 | Re: [HACKERS] Re: [INTERFACES] ODBC is slow with M$-Access Report |