On 12/5/07, Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> wrote: > Not that I know of. > > I think the simplest thing to get your tuples back is: > > 1. mark the transaction that deleted them as aborted in pg_clog > 2. reset the hint bits in the deleted tuples, or hack your postgres copy > to ignore hint bits > > You can figure out the transaction that deleted the tuples by seeing > that their Xmax value is with pg_filedump. > > The hint bits part makes it rather messy :-( A bit beyond me I'm afriad, at least at my current level with postgresql. Does anyone offer a commercial tool to do this? Or, would anyone be interested in doing it for a fee? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
