Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
I have a database (SQL Server in this case) that has a large number of tables. Every time I need to add a table, I typically go in and populate that table using the Import feature. The problem is, when the table is created, it doesn't show up without a refresh and the refresh tables only works when you right click on the User Tables folder and choose refresh or highlight the user tables folder and press F5. This forces me to have to scroll all the way up to the top every time. Could you add a refresh option when right-clicking or pressing F5 anywhere in the table list? In addition, intellisense doesn't work on a newly created table until it shows up in the table list which I'd like to see fixed as well. Intellisense should work on existing tables not just on tables that show up in a list.
Auto completion uses caching, otherwise the queries on the system catalog tables could put load on the server. The Query Window toolbar has a button called "Refresh Auto Schema" to clear the cache in the case that your objects list has changed.
Could you add a refresh option when right-clicking or pressing F5 anywhere in the table list
We should go ahead w/ adding a refresh option when right-clicking on an individual object such as table, view, etc.
Could you add a refresh option when right-clicking or pressing F5 anywhere in the table list
We should go ahead w/ adding a refresh option when right-clicking on an individual object such as table, view, etc.
We can use SchemaGUIUtil.refreshSelectedObjectParent()
We can use SchemaGUIUtil.refreshSelectedObjectParent()
Here are the minimum set of objects we should add "refresh" option to:
Here are the minimum set of objects we should add "refresh" option to:
SVN r30493 - Tables and Views are done.
To support this feature for each Schema Object, not only popup menu needs to be changed, but also the customization of the 'refresh' function. Table nodes have a common table-specific base class, so the customization for refresh function is easy, one change for all of supported servers. View nodes do not have a common view-specific base class, I need to modify the View Node class for each supported servers to bind the correct refresh function.
For Tables/Views implementation, I only tested the following servers: MySQL, SQL Server, and Greenplum.
Column implementation is yet to be done. Similar to View, Column nodes do not have a common column-specific base class; hence, I need to go to each Server and modify its Column node class manually to bind the correct refresh function. In addition, Column node class is shared by Table, View, Constraint and Index nodes, if we only want to support requested feature for Table/View columns, then I also need to modify column class' internal logic in each server, is it worth? I will discuss this with Sachin tomorrow.
SVN r30493 - Tables and Views are done.
To support this feature for each Schema Object, not only popup menu needs to be changed, but also the customization of the 'refresh' function. Table nodes have a common table-specific base class, so the customization for refresh function is easy, one change for all of supported servers. View nodes do not have a common view-specific base class, I need to modify the View Node class for each supported servers to bind the correct refresh function.
For Tables/Views implementation, I only tested the following servers: MySQL, SQL Server, and Greenplum.
Column implementation is yet to be done. Similar to View, Column nodes do not have a common column-specific base class; hence, I need to go to each Server and modify its Column node class manually to bind the correct refresh function. In addition, Column node class is shared by Table, View, Constraint and Index nodes, if we only want to support requested feature for Table/View columns, then I also need to modify column class' internal logic in each server, is it worth? I will discuss this with Sachin tomorrow.
SVN r30493 should have fulfilled the request feature (refresh table list). For Views and Columns, a separate issue (#8043) has been created. We will address Views and Columns from there.
SVN r30493 should have fulfilled the request feature (refresh table list). For Views and Columns, a separate issue (#8043) has been created. We will address Views and Columns from there.
Issue #7957 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build trunk/30493 |
| No time estimate |
1 issue link |
relates to #8043
Issue #8043Creating schema node specific base class for schema browser related classes |
Auto completion uses caching, otherwise the queries on the system catalog tables could put load on the server. The Query Window toolbar has a button called "Refresh Auto Schema" to clear the cache in the case that your objects list has changed.