Re: UNDO and partially commited transactions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: UNDO and partially commited transactions
Date
Msg-id 200107040058.f640wgC02729@candle.pha.pa.us
Whole thread Raw
In response to UNDO and partially commited transactions  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-hackers
> 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
 


pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: stuck spin lock with many concurrent users
Next
From: Bruce Momjian
Date:
Subject: Re: stuck spin lock with many concurrent users