Thread: Feature requests

 

First of all I would like to thank all who worked on the new pgAdmin: the new style and graphical explains are super!

 

Nevertheless I ran into a "bug", or maybe better: a feature-request. When one is creating a new foreign key via the tool, it is not possible to select "no action" for either "on update" or "on delete". This is a pitty, because "restrict", which is almost the same, doesn't allow constraints to be deferrable. In order to solve this, the constraints have to be made via the query tool.

 

Another request would be to able to "change" foreign key properties (like Deferrable, Deferred, On Update, etc..). When applying the changes pgAdmin would than drop the foreign key and recreate it with the new settings. To garanty consistency the table could be locked exclusively.

 

A final request would be to have "mouseover hints". This would really benefit new user (and experienced ones with new features)!

 

Hopefully these suggestions are usefull to you and can we benefit from them in the (near) future.