Message-ID: <4C74BF33.3080901@lelarge.info>
Date: Wed, 25 Aug 2010 08:58:59 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); fr;
	rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2
MIME-Version: 1.0
To: Thom Brown <thom@linux.com>
CC: Justin Graf <justin@magwerks.com>, Kevin.Grittner@wicourts.gov,
	depesz@depesz.com,
	postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Are Indices automatically generated for primary keys?
References: <AANLkTin-+Ezh_dFq5YjFoPhaN32QiiJigwP=hLm91+yK@mail.gmail.com>
	<4C6BA0F6020000250003481C@gw.wicourts.gov>
	<AANLkTintOGqZajm70ZAGdBOAwsLZ+P2WztpJNCLBYedt@mail.gmail.com>
	<4C6C050F.5050608@magwerks.com>
	<AANLkTineyC5zX0AmGgd4vaWouN9fWzjXeVqo2EJUee2n@mail.gmail.com>
In-Reply-To: <AANLkTineyC5zX0AmGgd4vaWouN9fWzjXeVqo2EJUee2n@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Le 18/08/2010 17:23, Thom Brown a écrit :
> On 18 August 2010 17:06, Justin Graf <justin@magwerks.com> wrote:
>> On 8/18/2010 9:15 AM, Clemens Eisserer wrote:
>>> Hi,
>>>
>>>
>>>> they are generated automatically.
>>>>
>>> Thanks depesz!
>>> The reason why I asked was because pgAdmin doesn't display the
>>> automatically created indices, which confused me.
>>>
>>> Thanks, Clemens
>>>
>> PGAdmin caches all database layout locally, the tree view can get very
>> stale.  So refresh the treeview with either F5 or right click an item in
>> the treeview click refresh to rebuild the list.
>>
> 
> I don't think PgAdmin will display indexes created by primary keys,
> only if indisprimary is false.
> 

pgAdmin doesn't display indexes for primary keys and unique constraints.
These objects are already displayed in the constraints nodes. The fact
that they use an index to enforce the constraints is an implementation
detail.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com