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
[...]