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"