psycopg2 leaves transactions open by default, which causes VACUUM to fail. Turning on autocommit disables this behavior.
Fixes #1762 This will potentially cause verbose mode to report a slightly different count than what actually gets deleted. If that's a concern, I can rewrite the reporting to use the result of the DELETE rather than the separate SELECT.
:thumbsup: I think, it is pretty ok for given usecase.
:thumbsup:
Commit 1a4fae67 fixes this pull-request
Pull-Request has been merged by tkopecek
Metadata Update from @jcupova: - Pull-request tagged with: testing-done
psycopg2 leaves transactions open by default, which causes VACUUM to
fail. Turning on autocommit disables this behavior.