[EMAIL PROTECTED] wrote:
Erwin Brandstetter wrote:
If any change via properties dialog would collapse the whole table
subtree that would be a change for the worse IMO. Then I'd rather have
the status quo ante.
Is there no way to just refresh the SQL pane?
Not really - it's generated from all the other bits of data. I updated
the .exe at http://developer.pgadmin.org/~dpage/pgadmin3.zip; try it out
and see what you think.
Thanks, got it and tested it.
Having the whole table subtree collapse with any adjustment kills the
workflow. If, for instance, I want to add /change comments for a dozen
fields of a table this quickly becomes a pain.
I see the SQL pane being out of date as the lesser pain under the given
circumstances. It also has advantages:
- The SQL pane can serve as a "backup" if you mess up. You can restore
the previous state from there.
- It teaches you to refresh the SQL pane before you work on it - which
is always a good idea.
- Less traffic /load on the database
If there was a cheaper way to cascade changes to SQL pane, I would
probably go for it.
If there isn't, how about this: add a timestamp to the header. Like this:
-- Table: foo (snapshot created: 2007-08-27 17:24:17)
-- DROP TABLE foo;
CREATE TABLE foo ....
Regards
Erwin
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend