Re: List to Father Christmas

Hi Laurent,

Laurent ROCHE a écrit :
> As
> I have managed to get error messages displaying correctly in PG-Admin

The correct spelling is pgAdmin :)

> (thanks to a correct configuration on the PG Server), I have switched
> to version 1.6.3, and I am sending this request feature list (I know
> it's not Christmas anymore, Easter is already gone passed ... but I
> always hope).
> [...]
> My feature request list:
> 
>     A/ Editor
> 
>  A-1/ Search & replace Cancel
> The "Cancel" button should be "Close": as hitting it does not cancel anything but just close the window.
> By
> the way in the French version, the second label "Remplacer par" is
> slightly too long, and overides the begining of the text field box.
> 

I can take care of this : - update the button's title ; - grow the Replace button.
Dave, do you agree on this ?

>  A-2/ History results
> Keeping the results of the query would be useful (as an option).
> In particular, for the next point !
> 
>  A-3/ History navigation
> Being able to navigate (previous/next) through the history of the requests typed in, would be really useful.
> That's a feature I used to have in a previous tool and I missed it a lot.
> 

Can you tell us what tool you used ? I want to see the interface, so I 
can better understand what you meant.

>     B/ Table Editor
> 
>  B-1/ modify new column
> It's
> really annoying that after creating a new column but still in the table
> editor, it's not possible to modify it (modify button greyed out).
> The
> typical thing is creating a new column not null, and entering a lengthy
> comment on the column. Then when I click OK on the table editor it's
> complaining that there are null values on that column (of course, I
> have just created it) so I want to correct the column definition (to
> make it NULLable for example) ... BUT I CAN'T ! ! ! I have to delete
> the column and then to create it again ! :-(
> 

There was some stuff done for this but it wasn't applied. One idea that 
came afterward was to display the SQL that failed and let the user 
change it. Unfortunately, I didn't find time to code it yet.

> [...]
>  C-3/ Edit Data window title
> The
> title of the Edit Data windows is note very helpful: it's too long and
> the very meaningful information (the table name) is at the end. So when
> I browse through my many EditData windows opened (see previous remark
> ;-) !), all I can see is the name the application, the name of the
> server and that's it. When I say browsing through my EditData windows,
> I mean either cycling through applications with Alt+Tab or hovering the
> icons in the task bar. And the text I get is typically:
> pgAdmin III Edit Data - Server ServNm (servnm:5432) - my_database_name_
> when I would like to see
> pgAdmin III Edit - table_name - my_database_name_ - ServNm
> (Note:
> The names table_name, my_database_name_, ServNm are quite
> representative in length of what I used on the many projects I have
> worked on in more than 10 years)
> To me I don't see, the point of having the full Server ServNm (servnm:5432): ServNm is enough.
> May
> be a solution will be to have the name configurable via preferences ?
> (in the long term, but in short term changing the order would be nice)
> 

And some would love to see the user name on it.

>  C-4/ Edit Data in Table Tab 
> It will be nice to have an extra tab in the table view (next to Properties, Statistics, Dependencies, Dependents):
EditData.
 
> That would be what we get when doing View Data ==> View Top 100 rows on that table.
> That will be really quicker when looking up data on a few tables.
> If performance is an issue for some people, that could be an option to turn on or off.
> 

Well performance is not really an issue. It can work as the dependencies 
tab where datas are fetched when the user clicks on the corresponding tab.

>  C-5/ new IDENTICAL Edit Data window
> Asking
> confirmation before opening a new IDENTICAL Edit Data window, would be
> nice (and offering to switch to the existing as an alternative).
> As
> the feature request C-4 is not already implemented, I often open many
> data windows to read the tables content. As I don't always remember
> what's already opened (age is not helping ;-) !), I open several times
> the same data windows !
> 

+1

> Thanks for reading that far ! ;-) 
> 

:)

Thanks for your wish list, it's always interesting to know what users 
are interested in.

Regards.


-- 
Guillaume.
<!-- http://abs.traduc.org/     http://lfs.traduc.org/     http://docs.postgresqlfr.org/ -->