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

From Christopher Kings-Lynne
Subject Re: Bug in DROP NOT NULL
Date
Msg-id 424CB069.3050600@familyhealth.com.au
Whole thread Raw
In response to Re: Bug in DROP NOT NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
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.

Chris


pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: [ADMIN] Excessive growth of pg_attribute and other system tables
Next
From: Christopher Kings-Lynne
Date:
Subject: New FLOSS survey