pgAdmin III July 16th Build.
OS: W2K SP4
There are loads of issues here and so I will start with just a few:
1) The only way to edit data is via view data. If I have a table that has 2000000 records I don't want to load them all into a view.
The old pgAdmin II had the ability to edit data from any result set query that you execute.
With this later method provided by pgAdmin II, one has total flexibility over selecting only a range of data and also allowing one to order the data in some sensible way.
Currently with pgAdmin III there is no ordering or ability to limit the data in the view for editing.
2) If I attempt to edit a column and then change my mind one would assume that pressing "Esc" would cancel editing. Not so with pgAdmin III, as soon as you change rows pgAdmin III automatically attempts to update the edited column/s. If I press the "return" key after editing a column pgAdmin III automatically attempts to save the column - fair enough, but then why doesn't "Esc" cancel editing?
I would have thought that the button - "Save the changed row", found on the tool bar of the view, would be sufficient. I know there is a button "Undo changed data", but I would prefer to have user instantiated save changes rather than automatic. (Only my opinion I know)
3) Not possible to edit multiple line data.
4) If I have a NULL integer value and I try and set it to zero I cannot. I have to set it to some other value first, like 1, and then set it to zero.
Regards
Donald Fraser