From: Guillaume Lelarge <guillaume@lelarge.info>
To: Thom Brown <thom@linux.com>
Cc: Justin Graf <justin@magwerks.com>
Cc: Kevin.Grittner@wicourts.gov, depesz@depesz.com, postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Are Indices automatically generated for primary keys?
Date: Wed, 25 Aug 2010 08:58:59 +0200
Message-ID: <4C74BF33.3080901@lelarge.info> (raw)
In-Reply-To: <AANLkTineyC5zX0AmGgd4vaWouN9fWzjXeVqo2EJUee2n@mail.gmail.com>
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>
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.frhttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: guillaume@lelarge.info, thom@linux.com, justin@magwerks.com
Subject: Re: Are Indices automatically generated for primary keys?
In-Reply-To: <4C74BF33.3080901@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox