psycopg2: How to execute vacuum postgresql query in python script

Question

I am using Python with psycopg2 and I'm trying to run a full VACUUM in python script. The problem is that when I try to run the VACUUM command within my code I get the following error:

psycopg2.InternalError: VACUUM cannot run inside a transaction block

The line which am trying to execute is:

sql="vacuum full table_name;"

cur.execute(sql)

How to resolve this error?

klin · Accepted Answer · 2022-10-04 12:44:54Z

16

Psycopg2 starts a new transaction for each call to .execute().

Open an autocommit connection to handle a vacuum.

Read about autocommit in the documentation.

edited Oct 4, 2022 at 12:44

klin

123k15 gold badges241 silver badges263 bronze badges

answered May 13, 2015 at 5:59

Ron Dunn

3,09822 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

psycopg2: How to execute vacuum postgresql query in python script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related