PostgreSQL has the ability to change the search path of a connection. We should see if we can provide the ability to change the schema context in the query window with the combo box, just like Oracle and DB2. PG has two SQL commands ...
which allow for this support.
USER: "It might be nice to allow users to type in a default search_path path in the server reg and/or to have a table that lists all the available schemas with a method to indicate the order desired so the path can be re-arranged while in a query analyzer window."
Initial implementation is in SVN #29680. If you "set search_path public, "$user" it will autocomplete with public schema objects twice. Ivan needs to review this issue.
public schema objects will no longer show up twice. This code will allow for changing the schema by using the first schema in the path but not to auto complete on all the schemas. code looks fine.
public schema objects will no longer show up twice. This code will allow for changing the schema by using the first schema in the path but not to auto complete on all the schemas. code looks fine.
This is broken in Version: 12.0.0. Ivan has fixed it and will test 344 and 7819 once a new build is available
This is broken in Version: 12.0.0. Ivan has fixed it and will test 344 and 7819 once a new build is available
Issue #344 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 12.0.0-1 |
No time estimate |
5 issue links |
relates to #9095
Issue #9095set search_path is not working for some users in PostgreSQL |
relates to #7799
Issue #7799PostgreSQL: database objects are displayed twice in public schema |
relates to #7866
Issue #7866Change the schema context and Execute Edit gives Failed to set current schema |
relates to #7819
Issue #7819Change the schema context using search_path and clone window with content |
relates to #7867
Issue #7867Reconnect button in Query Window is broken for PostgreSQL |
Initial implementation is in SVN #29680. If you "set search_path public, "$user" it will autocomplete with public schema objects twice. Ivan needs to review this issue.