Re: JDBC feature request: auto savepoint per command

On Mon, 23 Apr 2007, Tom Lane wrote:

> Can anyone see a solution for this in the context of the existing driver
> facilities?  If not, is it reasonable to ask for a driver option to do
> auto-savepointing?  There is already an equivalent facility in psql, so
> the idea doesn't seem unreasonable to me.
>

Previous discussions on this topic had the idea that auto-savepointing
would be done on a per-connection basis enabled via a URL parameter or
DataSource option.  In an application server would you have a separate
connection pool for auto-savepointing connections?  Would you force all
transactions to use auto-savepoints even if they didn't want/need them?
You could enable/disable it dynamically, but that would require pg
specific code, is that what they want to do?

Kris Jurka