Question about running "Vacuum" through JDBC

From: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about running "Vacuum" through JDBC
Date: 2005-05-06 15:22:35
Message-ID: 427B8BBB.2040808@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 "?

Thanks a lot,
Emi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2005-05-06 15:49:33 Re: Adventures in Quest for GUI RAD
Previous Message Richard Huxton 2005-05-06 15:11:31 Re: postmaster crash - another server process exited abnormally