Re: WIP: Deferrable unique constraints - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WIP: Deferrable unique constraints
Date
Msg-id 16885.1248875234@sss.pgh.pa.us
Whole thread Raw
In response to Re: WIP: Deferrable unique constraints  (Dean Rasheed <dean.a.rasheed@googlemail.com>)
List pgsql-hackers
Dean Rasheed <dean.a.rasheed@googlemail.com> writes:
> 2009/7/29 Tom Lane <tgl@sss.pgh.pa.us>:
>> � For non-unique indexes, it is not required that <function>aminsert</>
>> � do anything; it might for instance refuse to index NULLs.

> Doesn't this comment apply equally to unique indexes?

Hmm, I was thinking that a unique-capable index would have to index all
tuples.  But I guess if it's restricted to one index column (like hash)
it could omit nulls and still enforce uniqueness correctly.  I'll change
that comment.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: dependencies for generated header files
Next
From: Tom Lane
Date:
Subject: Re: Review: Revise parallel pg_restore's scheduling heuristic