Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Re: using indexes with the OR clause

From: David Hartwig <daveh(at)insightdist(dot)com>
To: Colin McKinnon <colin(at)wew(dot)co(dot)uk>
Cc: pgsql-interfaces(at)hub(dot)org
Subject: Re: [INTERFACES] Re: using indexes with the OR clause
Date: 1998-10-21 12:27:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces

Colin McKinnon wrote:

> Hello all,
> I'm a newbie to postgres (haven't got as far as setting up odbc on my
> system yet) so please forgive me if I'm talking ^&*%.
> At 23:00 20/10/98 -0400, you wrote:
> >Date: Tue, 20 Oct 1998 15:52:06 +0200
> >From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
> >Subject: using indexes with the OR clause
> >
> >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:
> <snip>
> It may be nothing to do with your error but I see from your code you allow
> NULL values as part of the primary key. The programming style is
> questionable, but Access is VERY particular about not having NULL values in
> JET tables so I suppose it could be the same for linked tables.
> I would try declaring each attribute of the primary key as NOT NULL.

In PostgreSQL the PRIMARY KEY clause forces an implied NOT NULL on each
specified column.

In response to

pgsql-interfaces by date

Next:From: David HartwigDate: 1998-10-21 12:39:53
Subject: Re: [HACKERS] Re: [INTERFACES] using indexes with the OR clause
Previous:From: John ReillyDate: 1998-10-21 11:12:49
Subject: Re: [INTERFACES] Where can I get documentation on the using the JDBC interface?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group