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)
Resolved in SVN 29929 -> We should not try to change the search_path when reconnecting.