Re: Run Vacuum Through JDBC - Mailing list pgsql-general

From Kris Jurka
Subject Re: Run Vacuum Through JDBC
Date
Msg-id alpine.BSO.2.00.1005111457130.11093@leary.csoft.net
Whole thread Raw
In response to Run Vacuum Through JDBC  (Yan Cheng CHEOK <yccheok@yahoo.com>)
List pgsql-general

On Mon, 10 May 2010, Yan Cheng CHEOK wrote:

> I was wondering, how can I check whether Vacuum operation had been
> executed without problem?
>
> final Statement st2 = connection.createStatement();
> st2.executeUpdate("VACUUM FULL ANALYZE VERBOSE");
> st2.close();
>
> Nothing print out at console.
>

The results of the vacuum are available in Statement.getWarnings().

Kris Jurka

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: can function arguments have the type tablename.columnname%TYPE?
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL 9.0 beta1 and pg_upgrade