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
