Attempts to run PostgreSQL VACUUM commands in a Worksheet always fail:
vacuum full verbose activities;
Error:
VACUUM cannot run inside a transaction block
Executed Statement:
vacuum full verbose activities;
Execution Started: 13:45:37
Execution Time: 0 ms
Is Toad Edge starting a transaction for every block executed by the worksheet?
Nor is there any other way to vacuum tables, such as a context menu option in Object Explorer, or a button on a table sheet.
Toad Edge 2.0.2
EnterpriseDB 10.5.12