| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Getting vacuum results |
| Date: | 2005-09-14 02:27:33 |
| Message-ID: | Pine.BSO.4.62.0509132123240.3277@leary.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mpr | 2005-09-14 19:12:42 | connection reset and I/O error |
| Previous Message | Joseph Shraibman | 2005-09-14 01:08:06 | Re: Getting vacuum results |