반품
-
제목
Option to set search_path default for PostgreSQL database. -
설명
Generally , there is no need to set search path in editor and it should take by default from your user profile. In search path you define all schema names which the database will try to search for the function/table/schema etc if it does not found in search path schema, it will give you failure.
Example:
show search_path;
Results: 'adp_hist_schema, public'Let say....in public schema you have table name XSQL query:
Select * from X will work without specifiying Schema Name for the table. If X is not available in any schema mentioned in Schema defined in search path, database will give error.In our case, a function is available in our default path but somehow TDA is not understanding it and required to manually type statement to reflect that path.Requesting an option to set the 'search_path' to the User's defined 'search_path' value. -
원인
TDA only looks in current schema and 'public'
-
해결 방안
WORKAROUND
Type 'set search_path = ...' in the editor prior to running a query
STATUS
Enhancement request ST86933 has been submitted to Development for consideration in a future release of Toad for Data Analysts.
-
결함 ID
ST86933