Toad World® Forums

Bug: Cannot execute PostgreSQL VACUUM in a worksheet


#1

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


#2

Hi, it seems you have set autocommit to OFF, please set it to ON and try again.
thanks
br.
Miroslav Stanik