Re: Unique Index

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Dann Corbit <DCorbit(at)connx(dot)com>
Cc: vhikida(at)inreach(dot)com, "J(dot) Greenlees" <jaqui(at)telus(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Unique Index
Date: 2005-01-20 00:26:30
Message-ID: 20050119162347.E92474@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Wed, 19 Jan 2005, Dann Corbit wrote:

> Even at that, I think that being able to insert more than one null value
> into a unique index should be considered as a bug (or diagnosed as an
> error).

AFAICT the UNIQUE constraint that it's used to model explicitly allows
multiple NULLs in the spec so I don't see making it error as being
terribly workable.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-01-20 00:28:11 Re: Unique Index
Previous Message Dann Corbit 2005-01-20 00:23:09 Re: Unique Index