Thread: recovery from idiot delete error

recovery from idiot delete error

From
calvin247@aol.com
Date:
Hello...

I'm in rather dire-straits here. I just mistakenly deleted all the 
entries in a table and I need to recover them. I'm told that there's 
something I can do along the lines of "hacking up a PG to show deleted 
'tuples'" ...

Any help would be VERY much appreciated.

--Joshua


Re: recovery from idiot delete error

From
Alvaro Herrera
Date:
On Tue, Apr 12, 2005 at 11:58:43AM -0400, calvin247@aol.com wrote:
> Hello...
> 
> I'm in rather dire-straits here. I just mistakenly deleted all the 
> entries in a table and I need to recover them. I'm told that there's 
> something I can do along the lines of "hacking up a PG to show deleted 
> 'tuples'" ...

What version is this?  In recents ones you can change
src/backend/utils/time/tqual.c or just compile with
-DMAKE_EXPIRED_TUPLES_VISIBLE in CFLAGS
and *I think* you should be able to see deleted tuples.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"La vida es para el que se aventura"