Re: No implicit index created when adding primary key with ALTER TABLE

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: No implicit index created when adding primary key with ALTER TABLE
Date: 2011-06-16 13:34:48
Message-ID: 58CE224F-7E6F-4AC4-8633-62800A4010DB@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 directly from 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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-06-16 13:39:04 Re: No implicit index created when adding primary key with ALTER TABLE
Previous Message Rick Harding 2011-06-16 13:29:49 Re: trouble building user defined agg function with plpython