× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2012-10-18T17:26:01Z  · last modified 2012-10-19T18:02:35Z

Change the schema context using search_path and clone window with content


Priority Low
Complexity Unknown
Component Q Analyzer
Version 12.0
Version: 12.0.0-rc-23-12
Build #: 29800
Build Date: 2012-Oct-18 06:57:50 AM
 
PostgreSQL: Change the schema context using search_path and clone window with content does not preserve the schema context.
 
1. Connect to postgresql 9.0.3 at 11.46 and open a query analyzer
2. Enter the below command and execute
set search_path = ivan
 
3. Execute the below query with a table from ivan schema
select * from table1
go
 
4.  Next right click inside the query window and perform a Clone window with content
 
5. Notice that the Schema is still ivan
 
6.  Execute the below query from ivan schame and you get an error  ERROR: relation "table1" does not exist
 
select * from table1
go
 
1 attachment

Issue #7819

Closed
Fixed
Resolved 2012-10-18T18:59:17Z
 
 
Completion
No due date
Fixed Build 12.0.0-rc-23-16
No time estimate

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