| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question about running "Vacuum" through JDBC |
| Date: | 2005-05-06 20:52:48 |
| Message-ID: | 20050506215248.E1711@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 |
+------------------------------+-------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonel Rienton | 2005-05-06 20:54:00 | Re: pg_ctl bug or feature? |
| Previous Message | Aaron Steele | 2005-05-06 20:51:45 | inherit with foreign key reference |