Re: [GENERAL] Question about running "Vacuum" through JDBC

2005-05-06 Thread Paul Thomas
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 t

Re: [GENERAL] Question about running "Vacuum" through JDBC

2005-05-06 Thread Brad Nicholson
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 ar

[GENERAL] Question about running "Vacuum" through JDBC

2005-05-06 Thread Ying Lu
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 ---(end of broadcast)--