Re: Discussion about posibility of integrating the grid editor and viewer

Hi Cameron,

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
cameron(at)braid(dot)com(dot)au
Sent: 26 August 2004 12:28
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Discussion about posibility of
integrating the grid editor and viewer


The 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