Re: Extracting more useful information from PSQLException

On Fri, 28 Dec 2012, Steven Schlansker wrote:

> While designing web services that are backed by PostgreSQL, it is often
> helpful to report a more useful HTTP error than a generic "Something
> went wrong, sorry dude".
>
> Is it possible / would it be a good addition to expose structured SQL
> error information through JDBC? If such a thing does not exist, is this
> a feasible contribution? I expect it might require some hacking on the
> PostgreSQL server side to expose the error information in a structured
> manner. Or am I just dreaming too much, and this is not feasible?
>

There is currently a patch in progress and under discussion for the server
changes to expose this information. I would recommend reviewing this and
joining the discussion on -hackers if you have something useful to
contribute. I don't know anything about the patch other than that it
exists. I would be useful to see how much the JDBC driver would have to
change to take advantage of it.

https://commitfest.postgresql.org/action/patch_view?id=843

Kris Jurka