Hi Cameron,
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: 26 August 2004 12:28
To: [EMAIL PROTECTED]
Subject: [pgadmin-support] Discussion about posibility of integrating the grid editor and viewerThe only condition is that the statement that you are executing is a "select * from ..." statement.I would LOVE it for pgadmin to support launching the grid editor as an embeded tab in the query window.
pgAdmin II used to allow
editting of query results, however it was virtually impossible to do reliably
due to the number of different things you could select from (functions,
sequences, views, multiple tables etc), and the difficulty involved in finding a
unique identifier for any given row (does MySQL always have such a column?
PostgreSQL doesn't anymore since OIDs were made optional). If there is only
single 'real' table in the query, with a primary key, then everything should be
pretty straight forward, however, often that is not the
case.
Perhaps a more appropriate solution in
this case would be to add a combobox to the top of the edit grid to allow a
different table to be selected. Andreas, you're quite touchy about the data
editor <grin> - what do you think?
Once again, thanks for such a valuable tool.
You're welcome - and thanks for the
feedback.
Regards,
Dave
