From 59191b2245be8458a2b063ba262218c2566e3f1f Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Sun, 20 Feb 2005 04:56:00 +0000
Subject: [PATCH] I have added a define, MAKE_ALL_TUPLES_VISIBLE, to help
 people recover deleted tuples. Of course it is only to be used for disaster
 recovery.

---
 src/backend/utils/time/tqual.c | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

diff --git a/src/backend/utils/time/tqual.c b/src/backend/utils/time/tqual.c
index cb1f7b4101..e16df0deb0 100644
--- a/src/backend/utils/time/tqual.c
+++ b/src/backend/utils/time/tqual.c
@@ -16,7 +16,7 @@
  * Portions Copyright (c) 1994, Regents of the University of California
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/utils/time/tqual.c,v 1.81 2004/12/31 22:02:56 pgsql Exp $
+ *	  $PostgreSQL: pgsql/src/backend/utils/time/tqual.c,v 1.82 2005/02/20 04:56:00 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -776,6 +776,11 @@ bool
 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)
-- 
2.40.0