From: | Nikolai Zhubr <n-a-zhubr(at)yandex(dot)ru> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Indexes generated for primary key are not show |
Date: | 2016-05-18 19:01:54 |
Message-ID: | 573CBC22.70008@yandex.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello all,
18.05.2016 20:09, Ненашев Илья Николаевич wrote:
> I has wasted a lot of time today has trying to find my autogenerated
> indexes for primary keys, which are not shown in PGAdmin III browser
> tree, until write and execute
> SELECT * FROM pg_indexes i WHERE i.tablename = <my table>;
> end have seen a real state of things.
>
> I expect from database admin tool to display clearly database objects
I'd desperately agree that the invisibility of primary indexes is quite
a strange feature. How do you even check such index's size and other
statistics then? (Ok, other than typing some sql by hand...)
Thank you,
Nikolai
> which are in database, without trying to hide some of them by some
> ridiculous reasons like a executability of generated script.
> Please DO NOT HIDE ANYTHING! When You hide something, I can't trust your
> tool!
>
> In SQL pane you can show DDL for object's like this inside a comment
> brackets /* and */ with preamble inside 'This index are automatically
> generated with constraint:'
>
>
> In late answer to:
>
> Because if any generated SQL contains both object, it will be an invalid
> script, not to mention the fact that you cannot properly recreate
[...]
From | Date | Subject | |
---|---|---|---|
Next Message | jeff stevens | 2016-05-20 13:20:53 | need ability to control line ending format in editor |
Previous Message | Bryan Tuck | 2016-05-18 18:44:45 | Poker Tracker 4 |