On Tue, Apr 12, 2005 at 11:58:43AM -0400, [EMAIL PROTECTED] 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 (<[EMAIL PROTECTED]>)
"La vida es para el que se aventura"
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
