Re: pgadmin 1.4.0-beta2 win feedback

-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org on behalf of Cybernd
Sent: Mon 10/17/2005 9:34 PM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] pgadmin 1.4.0-beta2 win feedback

> Hi guys
>
> Just some of my thoughts:

> When i refresh the root Node ( Servers(1) ), it leads to an empty gui.
> Might be a bug.

Yup, known bug, being worked on.

> File => open *.conf
> Why is it necessary to locate the conf file?
> I expected, that he will open the conf file of my selected server. (Or
> maybe he will remember the last chosen file)

That option is for editting any arbitrary config file. To edit the one on the connected server you need the instrumenation/admin pack installed on the server (it is by default with PostgreSQL on Windows). Then, you can use the option on the Tools -> Server configuration menu.

> Select Table => "view the data inside the table"
> Opens some kind of data viewer.
>
> I got one byta field containing some ziped information. It would be fine
> for me, when pg would offer the possibility to store the content of an
> selected table cell into a file for debug purposes.
> Copy&Paste is quite useless, because the file would contain all escape
> sequences.
>
> Should be rather easy to implement such feature.

Not necessarily - and it doesn't really fit with the purpose of the Edit Grid. That's more the job of the Query Tool which can already export data, though it might be useful to allow the export of a single cell (currently it exports the whole resultset, though that might be only one cell of course).

> pls add another button: "execute selected query"
> which should just execute the statment surrounding the current blinking
> line cursor.
>
> Its quite annoying to copy&paste several statements between the sql
> editor and some kind of editor ;o)
>
> Or is the magic plan, that we should copy paste older statments from the
> history?
> Just try toad free ;o) (if available) and you will know which kind of
> feature i mean.

No, it's works in the same way as MS SQL Server's Query Analyzer. Just select the query you want to run, and when you hit execute, only the highlighted text will be sent to the server.

> Maybe include the "data viewer" as additonal tab inside the main view.
> (next to the properties|statistics|dependsOn|referencedBy tabs).
> Would be fine to see the latest ?50? rows of each table within one
> mouseklick.

You can already view the contents of the table in a single click. The way it is a present, you can open multiple tables at once though.

> maybe as addon:
> allow the user to select several tables inside the selection tree
> lile strg + click

Few, if any treeviews allow you to select multiple nodes at once so this is unlikely to be possible.

Thanks for the suggestions,

Regards, Dave.