Re: Are Indices automatically generated for primary keys?

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Are Indices automatically generated for primary keys?
Дата
Msg-id AANLkTineyC5zX0AmGgd4vaWouN9fWzjXeVqo2EJUee2n@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Are Indices automatically generated for primary keys?  (Justin Graf <justin@magwerks.com>)
Ответы Re: Are Indices automatically generated for primary keys?  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-performance
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.

--
Thom Brown
Registered Linux user: #516935

В списке pgsql-performance по дате отправления:

Предыдущее
От: Justin Graf
Дата:
Сообщение: Re: Are Indices automatically generated for primary keys?
Следующее
От: Samuel Gendler
Дата:
Сообщение: write barrier question