Skip site navigation (1) Skip section navigation (2)

Re: Are Indices automatically generated for primary keys?

From: Thom Brown <thom(at)linux(dot)com>
To: Justin Graf <justin(at)magwerks(dot)com>
Cc: Kevin(dot)Grittner(at)wicourts(dot)gov, depesz(at)depesz(dot)com, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Are Indices automatically generated for primary keys?
Date: 2010-08-18 15:23:17
Message-ID: AANLkTineyC5zX0AmGgd4vaWouN9fWzjXeVqo2EJUee2n@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
On 18 August 2010 17:06, Justin Graf <justin(at)magwerks(dot)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.

-- 
Thom Brown
Registered Linux user: #516935

In response to

Responses

pgsql-performance by date

Next:From: Justin GrafDate: 2010-08-18 16:06:39
Subject: Re: Are Indices automatically generated for primary keys?
Previous:From: Kevin GrittnerDate: 2010-08-18 14:52:57
Subject: Re: Are Indices automatically generated for primary keys?

pgsql-general by date

Next:From: Vick KheraDate: 2010-08-18 15:29:19
Subject: Re: Accessing a database via AJAX scripts
Previous:From: Kevin GrittnerDate: 2010-08-18 14:52:57
Subject: Re: Are Indices automatically generated for primary keys?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group