by codebling » Thu Jul 26, 2012 7:12 pm
Ok, a couple of things here. I was trying to refresh the table data view by refreshing using the context menu refresh button for the table in the Database Navigator. But I think this is maybe just refreshing the Database Navigator data for all of the nodes under the table in the Navigator (or the whole Navigator view? Not sure..). It's ok if this is the behaviour, it's just not what I expected. The refresh button on the toolbar will also only refresh the Navigator if this is where the focus is. If the focus is on the table data, then the toolbar refresh button will refresh the table data, but this depends on the transactional mode, as you have mentioned. For 'read committed', contents are always refreshed. For 'repeatable read', contents are only refreshed if there has been a commit or rollback. This makes sense, though conceptually it seems weird that I have a commit button when I have only been doing 'SELECT' statements.
So I guess one possibility would be if both the refresh button in the table context menu and the refresh button on the toolbar refreshed both the table view and the Navigator view.