Postgres Pro
Downloads
Home   >   mailing lists

Re: No implicit index created when adding primary key with ALTER TABLE - Mailing list pgsql-general

From Scott Ribe
Subject Re: No implicit index created when adding primary key with ALTER TABLE
Date
Msg-id 58CE224F-7E6F-4AC4-8633-62800A4010DB@elevated-dev.com
Whole thread Raw
In response to Re: No implicit index created when adding primary key with ALTER TABLE  (Stefan Keller <sfkeller@gmail.com>)
List pgsql-general
Tree view 
On Jun 16, 2011, at 6:52 AM, Stefan Keller wrote:

> IMO this decision is actually questionable.

Agreed. One should not have to look at constraints to figure out if there's an index. One should be able to check that
directlyfrom the list of indexes. I would think this is really obvious. 

(But then again, db tools in general aren't really masters of the obvious when it comes to user interface...)

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-general by date:

Previous
From: "Igor Neyman"
Date:
Subject: Re: Constraint to ensure value does NOT exist in another table?
Next
From: Adrian Klaver
Date:
Subject: Re: No implicit index created when adding primary key with ALTER TABLE