2010/1/17 Jim Fulton <[email protected]>: > On Sat, Jan 16, 2010 at 1:03 PM, Laurence Rowe <[email protected]> wrote: >> I've had a request to add savepoint release support to zope.sqlalchemy >> as some databases seem to limit the number of savepoints in a >> transaction. >> >> I've added this in a branch of transaction here: >> svn+ssh://svn.zope.org/repos/main/transaction/branches/elro-savepoint-release >> >> >From the changelog: >> >> * Add support for savepoint.release(). Some databases only support a limited >> number of savepoints or subtransactions, this provides an opportunity for a >> data manager to free those resources. >> >> * Rename InvalidSavepointRollbackError to InvalidSavepointError (BBB >> provided.) >> >> If there are no objections, I shall merge this to trunk. > > I'll review and merge.
Great, thanks! > What does it mean to "release" a savepoint? How is this different from > aborting > a save point? I ask particularly in light of: > > On Sat, Jan 16, 2010 at 2:26 PM, Laurence Rowe <[email protected]> wrote: >> 2010/1/16 Laurence Rowe <[email protected]>: >>> I'm still not sure this will allow me to add savepoint release support >>> to zope.sqlalchemy, as SQLAlchemy has a concept of nested transactions >>> rather than savepoints. >>> http://groups.google.com/group/sqlalchemy/browse_thread/thread/7a4632587fd97724 >> >> Michael Bayer noted on the sqlalchemy group that on RELEASE SAVEPOINT >> Postgresql destroys all subsequent savepoints. My branch now >> implements this behaviour. For zope.sqlalchemy I commit the sqlalchemy substransaction on savepoint.release(). This translates to a RELEASE SAVEPOINT on postgresql, best described by their docs here: """ RELEASE SAVEPOINT destroys a savepoint previously defined in the current transaction. Destroying a savepoint makes it unavailable as a rollback point, but it has no other user visible behavior. It does not undo the effects of commands executed after the savepoint was established. (To do that, see ROLLBACK TO SAVEPOINT.) Destroying a savepoint when it is no longer needed allows the system to reclaim some resources earlier than transaction end. RELEASE SAVEPOINT also destroys all savepoints that were established after the named savepoint was established. """ http://developer.postgresql.org/pgdocs/postgres/sql-release-savepoint.html Laurence _______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - [email protected] https://mail.zope.org/mailman/listinfo/zodb-dev
