Re: rollback

On Wed, Jul 9, 2008 at 10:32 AM, Adrian Moisey
<adrian(at)careerjunction(dot)co(dot)za> 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