I have added this define to help people recover deleted tuples.
Of course it is only to be used for disaster recovery.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: src/backend/utils/time/tqual.c
===================================================================
RCS file: /cvsroot/pgsql/src/backend/utils/time/tqual.c,v
retrieving revision 1.81
diff -c -c -r1.81 tqual.c
*** src/backend/utils/time/tqual.c 31 Dec 2004 22:02:56 -0000 1.81
--- src/backend/utils/time/tqual.c 20 Feb 2005 04:52:13 -0000
***************
*** 776,781 ****
--- 776,786 ----
HeapTupleSatisfiesSnapshot(HeapTupleHeader tuple, Snapshot snapshot,
Buffer buffer)
{
+ /* This is to be used only for disaster recovery and requires serious
analysis. */
+ #ifdef MAKE_ALL_TUPLES_VISIBLE
+ return true;
+ #endif
+
if (!(tuple->t_infomask & HEAP_XMIN_COMMITTED))
{
if (tuple->t_infomask & HEAP_XMIN_INVALID)
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
