Re: Getting vacuum results

On Tue, 13 Sep 2005, Joseph Shraibman wrote:

> OK from the stack trace I figured out that I had to add a permission to
> java.policy.
>
> FYI this doesn't work:
>
> ResultSet rs = stmt.executeQuery("VACUUM VERBOSE profuser;");
>            SQLWarning warn = rs.getWarnings();
>


With both 8.0 and 8.1dev I get:

Exception in thread "main" org.postgresql.util.PSQLException: No results
were returned by the query.
     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:232)
     at Vacuum.main(Vacuum.java:9)

and this is the result that I would expect.

Kris Jurka