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

Re: Indexes generated for primary key are not show

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Constantin Stefanov" <cstef(at)mail(dot)ru>
Cc: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Indexes generated for primary key are not show
Date: 2004-02-09 10:34:39
Message-ID: 03AF4E498C591348A42FC93DEA9661B889F239@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: Constantin Stefanov [mailto:cstef(at)mail(dot)ru] 
> Sent: 09 February 2004 10:25
> To: Dave Page
> Cc: Andreas Pflug; pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Indexes generated for primary 
> key are not show
> 
> Well, I did not think you were talking about generated SQL. I 
> mean I would like to see these indexes in left part of main 
> pgadmin screen, where all other (user-created) indexes are 
> shown. I mostly do not look at the generated SQL, so I did 
> not think about it.
> Maybe for such indexes there should be no generated SQL when 
> you select it (or some text that warns that this index is 
> system-generated).

It's not so much about when you select those indexes, it's what happens
when you select the parent table and the index definition gets included
in the table definition (I realise that doesn't happen yet for indexes,
but the intention is that it will). That is of course, a relatively
minor problem.

The primary question remains though, why should we expose implementation
details of something like a primary key when we already show the primary
key itself? It's not like you cannot see the columns in it or anything.
Should we by the same argument show the triggers that implement foreign
keys, or rules that implement views?

Regards, Dave.

Responses

pgadmin-support by date

Next:From: Constantin StefanovDate: 2004-02-09 12:53:30
Subject: Re: Indexes generated for primary key are not show
Previous:From: Constantin StefanovDate: 2004-02-09 10:24:43
Subject: Re: Indexes generated for primary key are not show

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