Question about running "Vacuum" through JDBC

Поиск
Список
Период
Сортировка
От Ying Lu
Тема Question about running "Vacuum" through JDBC
Дата
Msg-id 427B8BBB.2040808@cs.concordia.ca
обсуждение исходный текст
Ответы Re: Question about running "Vacuum" through JDBC  (Brad Nicholson <bnichols@ca.afilias.info>)
Re: Question about running "Vacuum" through JDBC  (Paul Thomas <paul@tmsl.demon.co.uk>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: postmaster crash - another server process exited abnormally
Следующее
От: Brad Nicholson
Дата:
Сообщение: Re: Question about running "Vacuum" through JDBC