Feedback from recent training

* Want option to *never* put double-quotes around object names, even
when I use an uppercase character in a name.

* Why is Primary Key on different dialog than columns? Want a check box
to say that a column is the PK.

* Name of a Constraint should default to what Postgres will call it, so
that it's clear that a constraint *will* be assigned a name even if we
leave it blank (which is best practice to do so).

* PKs and Unique constraints should show as Indexes in addition to
showing as a Constraint. Unique indexes should show as Constraints. Yes,
they're different, slightly, but they're so close it's annoying to have
to guess.

* When you perform an action, why doesn't it refresh that aspect?

* Why are Schema Privs not shown on Grant Wizard for a specific Schema?
When we click on a schema it shows only table privs for that schema.
Schema privs must be accessed via Properties..Privileges tab, which is
non-intuitive.

* Want Copy/Paste objects between schemas.

* Want "Clone" object, which copies object but prompts for new name.

* Want option to make Login Roles appear on priv dialogs, not just Group
Roles.

* Want to be able to use SERIAL and BIGSERIAL types for columns

* Only show Object Type if there is at least one object of that type in
that Schema. De-clutters display. We can have a right-click dialog to
create a new object, with sub-menu to select object type.

* Disabling Rule object type visibility doesn't appear to work!?!

* Want to be able to specify ConnectionLimit for users via dialog

* If there are >20 (N?) objects, then show that using a breakdown. e.g.
A-C, D-G, H-M, N-S, T-V, W-Z. So when we have 100s of objects we can
still retain sanity.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support