Re: Bug in DROP NOT NULL - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Bug in DROP NOT NULL
Date
Msg-id 42514C84.5030408@familyhealth.com.au
Whole thread Raw
In response to Re: Bug in DROP NOT NULL  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Bug in DROP NOT NULL
List pgsql-hackers
>> I don't think that's a bug.  You may not intend ever to cluster on that
>> index again, and if you try it will tell you about the problem.
> 
> 
> Except it breaks the 'cluster everything' case:
> 
> test=# cluster;
> ERROR:  cannot cluster when index access method does not handle null values
> HINT:  You may be able to work around this by marking column "a" NOT NULL.

Any further comments on this?  I still think it's a bug, ie. an 
invariant that's not being maintained...

Chris


pgsql-hackers by date:

Previous
From: "Jim Buttafuoco"
Date:
Subject: Re: BuildFarm status: recent check failures
Next
From: Tom Lane
Date:
Subject: Re: BuildFarm status: recent check failures