On 06/05/2005 16:22 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 "?
You don't say what version of the DB and JDBC driver you're using but I have an app which does vavuums via JDBC no problem. Just make sure that you've setAutoCommit(true).
-- Paul Thomas +------------------------------+-------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+-------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
