recovery from idiot delete error
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
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"