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 | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | resolved | Resolution | fixed | ||
Product Version | 7.5.x | ||||
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 | ||||
Hello Carlos, 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. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
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 |