am Wed, dem 09.07.2008, um 15:59:00 +0200 mailte Adrian Moisey folgendes: > 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. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
