Re: Bug in DROP NOT NULL

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Re: Bug in DROP NOT NULL
Дата
Msg-id
42514C84.5030408@familyhealth.com.au
Ответ на
Re: Bug in DROP NOT NULL (Christopher Kings-Lynne)
Список
Дерево обсуждения
Bug in DROP NOT NULL Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Bug in DROP NOT NULL Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Bug in DROP NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: Bug in DROP NOT NULL Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Bug in DROP NOT NULL Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Bug in DROP NOT NULL Alvaro Herrera <alvherre@dcc.uchile.cl>
>> 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 по дате отправления
От: Jim Buttafuoco
Дата:
От: Tom Lane
Дата:
FAQ