| 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-13 22:21:35 |
| Message-ID: | Pine.BSO.4.62.0509131712530.31592@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Thu, 1 Sep 2005, Joseph Shraibman wrote:
> If I run VACUUM VERBOSE from jdbc, how do I get the output? There are no
> SQLWarnings attached to the resultset.
>
SQLWarnings are attached to the Statement because VACUUM does not produce
a query result. The attached test case shows this working
fine for me. The one complication is that vacuum puts out
some of its interesting information in the Detail: part of the
log message. The JDBC driver doesn't normally put this
information into the warning message, so you must either
increase the loglevel URL parameter or use the 8.1 series and
write pg specific code to access the individual fields of the
ServerErrorMessage class. We plan to increase the number of fields
used to construct the error string to include the Detail field, but
haven't gotten around to it yet.
Kris Jurka
| Attachment | Content-Type | Size |
|---|---|---|
| Vacuum.java | text/plain | 553 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Shraibman | 2005-09-13 22:52:34 | Re: Getting vacuum results |
| Previous Message | Tom Lane | 2005-09-13 22:18:40 | Re: ERROR: canceling query due to user request |