View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0008158||VALENTINA STUDIO||Other||public||2018-01-09 17:24||2018-02-20 10:09|
|Reporter||Carlos Fuentes||Assigned To||Sergey Pashkov|
|Target Version||8.0.x||Fixed in Version||8.0.x|
|Summary||0008158: Unable to create an additional connection to DB|
|Description||I have a long running query that is inserting many records and I am wanting to run another query in a separate connection to the same DB to check on the progress (how many records have been inserted so far etc). While that query is running, however, any query I run will just wait for the first one to finish.|
I tried opening another window thinking at if I opened my bookmark to the DB in the other window it would be a separate connection but it seems to be the same and when I clicked on a table in the schema browser both windows locked up and did not return till the query finished.
Is there no way to run a second connection from the same bookmark so that you can monitor the progress of long running queries?
|Tags||No tags attached.|
|Working with DB:||postgreSQL Server|
|Version of your DB||latest|
No, currently, bookmark doesn't allow to open the second connection, only manually via connect dialog.
I think we can implement it for the context menu item - "Open Connection" (it clearly states that the connection will be opened).
|That would be great! Any idea why clicking on a table in the second window locked up the app? (I got the spinning beach ball on the Mac)|
|During executing a query in the first window? Yes, the same problem - the connection is locked by the SQL Editor.|
Fix will be available in the version 8.0.1.
A new connection is opened from the context menu of the bookmark.
Also, it was possible to set an option "Open in separate connection" for the bookmark earlier, but it opens a new connection each time the bookmark clicked.
|2018-01-09 17:24||Carlos Fuentes||New Issue|
|2018-01-09 17:40||Sergey Pashkov||Note Added: 0010015|
|2018-01-09 19:23||Carlos Fuentes||Note Added: 0010016|
|2018-01-09 19:28||Sergey Pashkov||Note Added: 0010017|
|2018-02-20 10:06||Sergey Pashkov||Product Version||=> 7.5.x|
|2018-02-20 10:06||Sergey Pashkov||Target Version||=> 8.0.x|
|2018-02-20 10:09||Sergey Pashkov||Note Added: 0010066|
|2018-02-20 10:09||Sergey Pashkov||Status||new => resolved|
|2018-02-20 10:09||Sergey Pashkov||Fixed in Version||=> 8.0.x|
|2018-02-20 10:09||Sergey Pashkov||Resolution||open => fixed|
|2018-02-20 10:09||Sergey Pashkov||Assigned To||=> Sergey Pashkov|