On Thu, May 27, 2004 at 23:02:42 +0000, Peter Galbavy <[EMAIL PROTECTED]> wrote: > Bruno Wolff III wrote: > >For long running transactions where you want to recover as much as > >possible, > >one might also want to recover up until just before a specific transaction > >committed (as opposed to started). > > If your DB has died and you are recovering it, how do you reestablish a > session so that a transaction can complete ? Doesn't all client > connections assume that a transaction has failed if the connection to > the DB fails ?
The context of my suggestion was for recovering up until a transaction which messed things up was committed. I did not want the problem transaction to be committed. If the problem transaction ran for a long time, there might be other transactions that I want to keep, if possible, that committed after the problem transaction started and before it ended. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html