× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2012-10-25T21:27:37Z  · last modified 2012-10-30T16:23:38Z

Change the schema context and Execute Edit gives Failed to set current schema


Priority Major
Complexity Unknown
Component Q Analyzer
Version 12.0
Product: Aqua Data Studio
Version: 12.0.2
Build #: 29911
Build Date: 2012-Oct-24 03:25:12 PM
 
PostgreSQL
 
1. Connect to postgresql 9.1.1 and in server registration change your database to postgres
2. Enter the command below
select * from pg_catalog.pg_locks
go
 
3. Do execute edit (CTRL+ ALT+ ENTER)
 
4. You get an error
"Failed to set current schema"
 
5. If you look in SQL LOG, the query generated is Detail: schema "postgres" does not exist, but if you look under the schema name in the query analyzer, it displays postgres
 
SET
    SEARCH_PATH = "postgres"
 
and you get org.postgresql.util.PSQLException: ERROR: invalid value for parameter "search_path": "postgres"
  Detail: schema "postgres" does not exist
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:364)
    at \\...\\ .\\हिñçêČάй語简�?한\\.nᛗᚵᠺ͕ public throw.execute(Unknown Source)
    at \\...\\ .\\हिñçêČάй語简�?한\\.cꈜ⣝ꋘꂑ goto public.a(Unknown Source)
    at com.aquafold.datastudio.queryanalyzer.o̎ꍙ᠎ꆢ char.changeSchemaDatabase(Unknown Source)
    at com.aquafold.datastudio.queryanalyzer.o̎ꍙ᠎ꆢ char.run(Unknown Source)
1 attachment

Issue #7866

Closed
Fixed
Resolved 2012-10-26T19:27:56Z
 
 
Completion
No due date
Fixed Build 12.0.3
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017