Q: "VACUUM cannot run inside a transaction block" on postgres, alembic and sqlalchemy After dropping a big column in Postgres with alembic, I want to clear it's used space so I'd like to run a VACCUM FULL.
When trying to execute the command I get the following error:
sqlalchemy.exc.ProgrammingError: (pg8000.dbapi.ProgrammingError) {'S': 'ERROR', 'V': 'ERROR', 'C': '25001', 'M': 'VACUUM cannot run inside a transaction block', 'F': 'xact.c', 'L': '3410', 'R': 'PreventInTransactionBlock'}
[SQL: VACUUM FULL]

I've tried solutions I found online for other DB types, such as:
    with op.get_context().autocommit_block():
        op.execute("VACUUM FULL")

Or any usage of with op.get_bind() as session; session.autocommit = True, but the same error occurs.
Any chance you know what could solve this one?
Thank you!
