Ying Lu wrote:
Greetings,
I tried to "Vacuum table" through JDBC. I got the following errors:
ERROR: VACUUM cannot run inside a transaction block
Does it mean I should only run vacuum through the command line such as "psql> vacuum TableName "?
Nope, it means exactly what the error says. You are trying to run vacum inside a transaction, which can't be done. JDBC is likely opening a transaction for you automatically. Stop it from doing this, and you should be able to vacuum.
--
Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
