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
[...]
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
