On Wed, Jul 9, 2008 at 10:32 AM, Adrian Moisey <adrian@xxxxxxxxxxxxxxxxxxxx> wrote: > Hi > >>>>> I would like to be able to "mark" a point in my postgres database. >>>>> After that I want to change a few things and "rollback" to that point. Does >>>>> postgres support such a thing? Is it possible for me to do this? >>>> >>>> Well, transactions do that. If you want to do this inside a >>>> transaction, the term you're looking for is "savepoints". >>> >>> I would like to do this globally over the entire DB, is that possible? >> >> Sure. You can start a transaction, create tables, drop tables, do >> inserts and deletes, update some tables, create and delete functions, >> triggers, views and schemas. After that, rollback. No problem. > > Can I do this outside of a transaction? yes. you need to check out pitr. merlin
