using indexes with the OR clause - Mailing list pgsql-interfaces

From Sferacarta Software
Subject using indexes with the OR clause
Date
Msg-id 11661.981020@bo.nettuno.it
Whole thread Raw
List pgsql-interfaces
Hi all,

I'm trying v6.4beta2 via ODBC-Access.

I have the following table:

CREATE TABLE attivita (
        azienda                 CHAR(11) NOT NULL,
        attivita                CHAR(03) NOT NULL,
        specifica               CHAR(02),
        cod_alternativo         CHAR(10),
        conto_economico         CHAR(02),
        inizio_attivita         DATE,
        fine_attivita           DATE,
        PRIMARY KEY (azienda,attivita,specifica,inizio_attivita)
        );

I linked this table on M$-Access specifying the Access-key equal to
PostgreSQL PRIMARY KEY to test indexes with the OR clause but
I have the following error message:

'FATAL 1: palloc failure memory exhausted'

Any ideas ?

There's the PSLODBC.LOG file attached.

Jose'



pgsql-interfaces by date:

Previous
From: David Hartwig
Date:
Subject: Re: [INTERFACES] C++ Builder (Delphi), ODBC and large objects
Next
From: "Leslie F. Donaldson"
Date:
Subject: ecpg features????