Unique Index - Mailing list pgsql-general

From Alex
Subject Unique Index
Date
Msg-id 41EE7034.6070803@meerkatsoft.com
Whole thread Raw
Responses Re: Unique Index  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: Unique Index  (Roman Neuhauser <neuhauser@chello.cz>)
List pgsql-general
Hi,

i have a unique index on a table over multiple columns. If now one of
the records has a null value in one of the indexed columns i can insert
the same record multiple times.

Is this a problem within postgres or expected?

Example:

index unique, btree (colA, colB, colC);

would still allow me to insert

AAAA, ,CCCC
AAAA, ,CCCC


Thanks for any help on that.
A



pgsql-general by date:

Previous
From: Clive Page
Date:
Subject: Re: Postgres crashed when adding a sequence column
Next
From: Robby Russell
Date:
Subject: Re: PostgreSQL 8.0.0 Released