Index: src/backend/commands/vacuum.c
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/commands/vacuum.c,v
retrieving revision 1.195
diff -c -r1.195 vacuum.c
*** src/backend/commands/vacuum.c	2001/05/25 15:45:32	1.195
--- src/backend/commands/vacuum.c	2001/06/13 18:46:01
***************
*** 159,166 ****
  static bool enough_space(VacPage vacpage, Size len);
  static void init_rusage(VacRUsage *ru0);
  static char *show_rusage(VacRUsage *ru0);
  
- 
  /*
   * Primary entry point for VACUUM and ANALYZE commands.
   */
--- 159,166 ----
  static bool enough_space(VacPage vacpage, Size len);
  static void init_rusage(VacRUsage *ru0);
  static char *show_rusage(VacRUsage *ru0);
+ static void check_limits(void);
  
  /*
   * Primary entry point for VACUUM and ANALYZE commands.
   */
***************
*** 236,241 ****
--- 236,242 ----
  
  	/* clean up */
  	vacuum_shutdown();
+ 	check_limits();
  }
  
  /*
***************
*** 2645,2648 ****
--- 2646,2674 ----
  			 (int) (ru1.tv.tv_usec - ru0->tv.tv_usec) / 10000);
  
  	return result;
+ }
+ 
+ /*
+  *	check if we are near OID or XID wraparound
+  */
+ static void check_limits(void)
+ {
+ 	Oid nextOid;
+ 
+ 	/* If we are 75% to the limit, warn the user */
+ 	if (GetCurrentTransactionId() >
+ 		~(TransactionId)0 - (~(TransactionId)0) / 4)
+ 		elog(NOTICE,"You are %.0f%% from the limit for transaction ids.\n"
+ 			"\t Dumping your databases, running initdb, and reloading will reset\n"
+ 			"\t the transaction id counter.",
+ 			GetCurrentTransactionId() - (float)(~(TransactionId)0) * 100);
+ 
+ 	/* If we are 75% to the limit, warn the user */
+ 	GetNewObjectId(&nextOid);
+ 	if (nextOid > ~(Oid)0 - (~(Oid)0) / 4)
+ 		elog(NOTICE,"You are %.0f%% from the limit for object ids.\n"
+ 			"\t If you are not using object ids as primary keys, dumping your\n"
+ 			"\t databases, running initdb, and reloading will reset\n"
+ 			"\t the oid counter.",
+ 			(float)nextOid / (float)~(Oid)0 * 100);
  }