Bug in DROP NOT NULL - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Bug in DROP NOT NULL
Date
Msg-id 424BBD7E.8080808@familyhealth.com.au
Whole thread Raw
Responses Re: Bug in DROP NOT NULL  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
You can drop a NOT NULL on a column, even if that column is part of an 
index that is clustered, where the index does not index NULLs.

Also, I dont think that ALTER TABLE blah CLUSTER ON foo; actually warns 
about clustering a non-null indexing index.  However, CLUSTER foo ON 
blah; does.

Chris


pgsql-hackers by date:

Previous
From: Marian POPESCU
Date:
Subject: Re: ARC patent
Next
From: Teodor Sigaev
Date:
Subject: Re: TSearch2 performance issue?