View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002242 | Database Workbench v6 | PostgreSQL Module | public | 2024-06-26 13:58 | 2024-06-27 11:36 |
| Reporter | Svein Erling Tysvær | Assigned To | Martijn Tonies | ||
| Priority | low | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | won't fix | ||
| Product Version | 6.5.0 | ||||
| Summary | 0002242: Strange explain analyse | ||||
| Description | If I type explain analyze select * from <database>.<table> in the SQL editor window and run, I do get a result. If I prepare the query, I get 'syntax error at or near "explain"' If I try to run after a prepare, I get "current transaction is aborted, commands ignored until end of transaction block" | ||||
| Additional Information | PostgreSQL 13.9 | ||||
| Tags | No tags attached. | ||||
|
|
EXPLAIN statements cannot be prepared. As this raises an error from PostgreSQL, your transaction is now 'aborted' and should be rolled back or committed. You can do this by clicking the 'start' and then 'commit' or 'rollback' button. I know, this sounds silly, but this is the case with PostgrSQL transactions. more info about how PostgreSQL handles such transactions: https://stackoverflow.com/a/13103690 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-06-26 13:58 | Svein Erling Tysvær | New Issue | |
| 2024-06-27 11:36 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2024-06-27 11:36 | Martijn Tonies | Status | new => closed |
| 2024-06-27 11:36 | Martijn Tonies | Resolution | open => won't fix |
| 2024-06-27 11:36 | Martijn Tonies | Note Added: 0000614 |
