Re: Setting a pre-existing index as a primary key

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Setting a pre-existing index as a primary key
Дата
Msg-id 48250CEF.4090802@commandprompt.com
обсуждение исходный текст
Ответ на Re: Setting a pre-existing index as a primary key  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Setting a pre-existing index as a primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Bruce Momjian wrote:
> Added to TODO:
> 
>> Proposed Implementation
>>
>> 1. Verify that the index named is a unique index
>> 2. Check index columns for NOT NULL constraints
>> 3. If indexed columns are not already NOT NULL, apply NOT NULL
>> 4. If NOT NULL succeeds, complete the operation (catalogs,
>> dependencies, ...), else bail out.
>>
>> Any comments, ideas, suggestions?

I would add:
  5. Modify index name to use appropriate naming style.

Joshua D. Drake




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Hodges
Дата:
Сообщение: Re: Deterministic locking in PostgreSQL
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: gsoc08, text search selectivity, pg_statistics holding an array of a different type