Re: Getting vacuum results - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Getting vacuum results
Date
Msg-id Pine.BSO.4.62.0509132123240.3277@leary.csoft.net
Whole thread Raw
In response to Re: Getting vacuum results  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-jdbc

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


pgsql-jdbc by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: Getting vacuum results
Next
From: "mpr"
Date:
Subject: connection reset and I/O error