hashidx_pre_96_is_not_recommended_for_unlogged.patch

text/x-patch

Filename: hashidx_pre_96_is_not_recommended_for_unlogged.patch

Type: text/x-patch

Part: 0

Message: Re: hash index on unlogged tables doesn't behave as expected

Patch

Format: context

File	+	−
src/backend/commands/indexcmds.c	1	0

*** a/src/backend/commands/indexcmds.c
--- b/src/backend/commands/indexcmds.c
***************
*** 501,507 **** DefineIndex(Oid relationId,
  	amRoutine = GetIndexAmRoutine(accessMethodForm->amhandler);
  
  	if (strcmp(accessMethodName, "hash") == 0 &&
! 		RelationNeedsWAL(rel))
  		ereport(WARNING,
  				(errmsg("hash indexes are not WAL-logged and their use is discouraged")));
  
--- 501,507 ----
  	amRoutine = GetIndexAmRoutine(accessMethodForm->amhandler);
  
  	if (strcmp(accessMethodName, "hash") == 0 &&
! 		!RelationUsesLocalBuffers(rel))
  		ereport(WARNING,
  				(errmsg("hash indexes are not WAL-logged and their use is discouraged")));