• Navigator and completion list

- fixed issues for deletion of a db like remove all relevant items and refresh the navigator
- simplified and minimized code and memory usage while querying the connection structure
- whether a schema name is an unique db or table will be evaluated on run-time via allKeysofDbStructure

1 files changed, 7 insertions, 1 deletions

diff --git a/Source/TableDocument.m b/Source/TableDocument.m
index 1b39a9c4..8663cc21 100644
--- a/Source/TableDocument.m
+++ b/Source/TableDocument.m
@@ -4098,7 +4098,13 @@
 		return;
 	}
 
-	[[SPNavigatorController sharedNavigatorController] removeDatabase:[self database] forConnectionID:[self connectionID]];
+	// Remove db from navigator and completion list array,
+	// do to threading we have to delete it from 'allDatabases' directly
+	// before calling navigator
+	[allDatabases removeObject:[self database]];
+	// This only deletes the db and refreshes the navigator since nothing is changed
+	// that's why we can run this on main thread
+	[mySQLConnection queryDbStructureAndForceUpdate:nil];
 
 	// Delete was successful
 	if (selectedDatabase) [selectedDatabase release], selectedDatabase = nil;