From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Eduardas Tcpa <tcpa41(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgAdmin 3 index display problem |
Date: | 2010-11-01 13:53:17 |
Message-ID: | AANLkTikyT2OawDyJdx8H0E7E842qMFF6ib34hJGFLWjQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1 November 2010 13:41, Eduardas Tcpa <tcpa41(at)gmail(dot)com> wrote:
> Hello I'm getting into strange problem with pgAdmin 3.
>> As we all know, PostgreSQL enforces index creation on primary key's.
>> The problem with this is the fact, that when i create a table in pgAdmin's
>> sql editor, in result window i'm getting success and a note that an index
>> will be created on tables pripamary key - problem, when I am browsing
>> through table structure in my public schema, under newly created table in
>> index section there are no indexes until I create one explicitly.So does it
>> create an index?and it's pgAdmin's bug not displaying the auto created
>> index, or it works in such way - not displaying the auto index?
>>
>> PostgreSQL version: 9.0.1
>>
>
>
Yes, it will always create a unique index for primary keys, but just not
visible in pgAdmin as an actual index. The fact a primary key is there
(listed in the contraints node) indicates that it automatically has an index
anyway. And the name shown in constraints is the name of the index.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
From | Date | Subject | |
---|---|---|---|
Next Message | Eduardas Tcpa | 2010-11-01 13:53:20 | pgAdmin 3 index display problem |
Previous Message | Eduardas Tcpa | 2010-11-01 13:41:45 | Re: pgAdmin 3 index display problem |