Commit949ebbd

committed

Mention MD5 function index for indexing long values.

1 parente8b842b commit949ebbdCopy full SHA for 949ebbd

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $PostgreSQL: pgsql/src/backend/access/nbtree/nbtinsert.c,v 1.123 2005/08/1022:39:00 tgl Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/backend/access/nbtree/nbtinsert.c,v 1.124 2005/08/11 13:22:33 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -394,7 +394,7 @@ _bt_insertonpg(Relation rel,`
`394`	`394`	`(unsigned long)itemsz,`
`395`	`395`	`(unsigned long)BTMaxItemSize(page)),`
`396`	`396`	`errhint("Values larger than 1/3 of a buffer page cannot be indexed.\n"`
`397`		`-"Consider aseparate column containing an MD5 hash of the value, "`
	`397`	`+"Consider afunction index of an MD5 hash of the value, "`
`398`	`398`	`"or use full text indexing.")));`
`399`	`399`
`400`	`400`	`/*`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -56,7 +56,7 @@`
`56`	`56`	`* Portions Copyright (c) 1994, Regents of the University of California`
`57`	`57`	`*`
`58`	`58`	`* IDENTIFICATION`
`59`		`- * $PostgreSQL: pgsql/src/backend/access/nbtree/nbtsort.c,v 1.93 2005/08/1022:39:00 tgl Exp $`
	`59`	`+ * $PostgreSQL: pgsql/src/backend/access/nbtree/nbtsort.c,v 1.94 2005/08/11 13:22:33 momjian Exp $`
`60`	`60`	`*`
`61`	`61`	`*-------------------------------------------------------------------------`
`62`	`62`	`*/`
`@@ -500,7 +500,7 @@ _bt_buildadd(BTWriteState wstate, BTPageState state, BTItem bti)`
`500`	`500`	`(unsigned long)btisz,`
`501`	`501`	`(unsigned long)BTMaxItemSize(npage)),`
`502`	`502`	`errhint("Values larger than 1/3 of a buffer page cannot be indexed.\n"`
`503`		`-"Consider aseparate column containing an MD5 hash of the value, "`
	`503`	`+"Consider afunction index of an MD5 hash of the value, "`
`504`	`504`	`"or use full text indexing.")));`
`505`	`505`
`506`	`506`	`if (pgspc<btisz\|\|pgspc<state->btps_full)`

Comments

(0)