Thread: UNDO and partially commited transactions

UNDO and partially commited transactions

From

Martín Marqués

Date:

03 July 2001, 21:34:22

I was reading the WAL documentation, and found out that UNDO is going to let 
PostgreSQL allow to make partial rollbacks on invalid transactions.

What does this exactly mean? Does it mean that if I have 6 Inserts in between 
a begin work - commit work some will get through and the ones with errors no?

Saludos... :-)

-- 
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica                      Universidad Nacional
        del Litoral
 
-----------------------------------------------------------------

Re: UNDO and partially commited transactions

From

Bruce Momjian

Date:

03 July 2001, 23:59:06

> I was reading the WAL documentation, and found out that UNDO is going to let 
> PostgreSQL allow to make partial rollbacks on invalid transactions.

We already "undo" aborted transactions, but without using the WAL log. 
Not sure if we will ever add that feature to WAL.

> What does this exactly mean? Does it mean that if I have 6 Inserts in between 
> a begin work - commit work some will get through and the ones with errors no?

No, they all fail.  No worries.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026