Re: Bug in DROP NOT NULL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in DROP NOT NULL
Date: 2005-03-31 14:59:55
Message-ID: 5419.1112281195@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2005-03-31 16:02:19 Re: TSearch2 performance issue?
Previous Message Alvaro Herrera 2005-03-31 14:45:36 Re: Understanding pg_xlog

Browse pgsql-patches by date

  From Date Subject
Next Message Michael Fuhr 2005-03-31 18:15:40 Re: HEAD \df doesn't show functions with no arguments
Previous Message Christopher Kings-Lynne 2005-03-31 12:53:53 Re: Bug in DROP NOT NULL