Re: recovery from idiot delete error

On Tue, Apr 12, 2005 at 11:58:43AM -0400, calvin247(at)aol(dot)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[(at)]dcc(dot)uchile(dot)cl>)
"La vida es para el que se aventura"