On Wed, Jul 9, 2008 at 10:32 AM, Adrian Moisey <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general