Postgres Pro
Downloads
Home   >   mailing lists

Question about running "Vacuum" through JDBC - Mailing list pgsql-general

From Ying Lu
Subject Question about running "Vacuum" through JDBC
Date
Msg-id 427B8BBB.2040808@cs.concordia.ca
Whole thread Raw
Responses Re: Question about running "Vacuum" through JDBC
Re: Question about running "Vacuum" through JDBC
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: postmaster crash - another server process exited abnormally
Next
From: Brad Nicholson
Date:
Subject: Re: Question about running "Vacuum" through JDBC