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: | 362DD338.9E52E89B@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David Hartwig | 1998-10-21 12:39:53 | Re: [HACKERS] Re: [INTERFACES] using indexes with the OR clause |
Previous Message | John Reilly | 1998-10-21 11:12:49 | Re: [INTERFACES] Where can I get documentation on the using the JDBC interface? |