Re: Setting a pre-existing index as a primary key - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Setting a pre-existing index as a primary key
Date
Msg-id 48250CEF.4090802@commandprompt.com
Whole thread Raw
In response to Re: Setting a pre-existing index as a primary key  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Setting a pre-existing index as a primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Robert Hodges
Date:
Subject: Re: Deterministic locking in PostgreSQL
Next
From: Alvaro Herrera
Date:
Subject: Re: gsoc08, text search selectivity, pg_statistics holding an array of a different type