Re: Bug in DROP NOT NULL

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in DROP NOT NULL
Date: 2005-04-01 02:22:33
Message-ID: 424CB069.3050600@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-04-01 02:56:12 New FLOSS survey
Previous Message Qingqing Zhou 2005-04-01 01:50:49 Re: [ADMIN] Excessive growth of pg_attribute and other system tables

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-04-01 04:34:02 Re: HEAD \df doesn't show functions with no arguments
Previous Message Greg Sabino Mullane 2005-04-01 00:08:43 Re: HEAD \df doesn't show functions with no arguments