Re: Solution for rolling back many transactions?

Phillip Tornroth wrote:
> In case it's useful information, the test database is pretty small...
> Maybe 15 or 20 megs. The unit tests are individually pretty small.. Less
> than 100 inserts each, for sure... So there's not that much to 'roll
> back'.. As far as using transactions to undo the state of the database,
> let me know if that's possible.. All of our tests have their own
> transaction boundaries that they're applying. I don't want to undo that,
> but certainly if I could nest each test in a longer-running tx and then
> roll it back.. that could work.
>

I use savepoints for my test framework.

Within a single transaction create savepoints and run your tests. When
you are done, simply rollback the entire transaction. Within your tests,
you can commit or rollback individual savepoints.

http://www.postgresql.org/docs/current/static/sql-savepoint.html

Regards,
LL