Re: Recovery Features - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Recovery Features
Date
Msg-id 4104.1089063056@sss.pgh.pa.us
Whole thread Raw
In response to Recovery Features  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Recovery Features  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> ...While recovering, it is very straightforward to simply ignore every
> record associated with one (or more) transactions. That gives us the
> ability to recover "all apart from txnid X".

Don't even *think* of going there.

What will happen when transaction Y comes along and wants to modify or
delete a row that was inserted by X?  There's no chance of staying
consistent.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: subtransactions and FETCH behaviour (was Re: PREPARE and transactions)
Next
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] [CHECKER] 4 memory leaks in Postgresql 7.4.2