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

From Tom Lane
Subject Re: Bug in DROP NOT NULL
Date
Msg-id 5419.1112281195@sss.pgh.pa.us
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
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> 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.

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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Understanding pg_xlog
Next
From: Teodor Sigaev
Date:
Subject: Re: TSearch2 performance issue?