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

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

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