diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-08-10 21:36:46 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-08-10 21:36:46 +0000 |
| commit | 237be3cc2945ad5216bf227a1ee2c47a29818167 (patch) | |
| tree | 04ffecae37963c99cb6dccac7c403646f6611c7f /src/backend/access/nbtree | |
| parent | 8bbf227ad742ce83e0665604ae099f0d9af70aa8 (diff) | |
Add hints to cases where indexes fail because of values that are too long.
Diffstat (limited to 'src/backend/access/nbtree')
| -rw-r--r-- | src/backend/access/nbtree/nbtinsert.c | 7 | ||||
| -rw-r--r-- | src/backend/access/nbtree/nbtsort.c | 7 |
2 files changed, 10 insertions, 4 deletions
diff --git a/src/backend/access/nbtree/nbtinsert.c b/src/backend/access/nbtree/nbtinsert.c index 9b9fa44e6ed..a613b6b978f 100644 --- a/src/backend/access/nbtree/nbtinsert.c +++ b/src/backend/access/nbtree/nbtinsert.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/access/nbtree/nbtinsert.c,v 1.121 2005/06/06 20:22:57 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/access/nbtree/nbtinsert.c,v 1.122 2005/08/10 21:36:45 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -392,7 +392,10 @@ _bt_insertonpg(Relation rel, (errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED), errmsg("index row size %lu exceeds btree maximum, %lu", (unsigned long) itemsz, - (unsigned long) BTMaxItemSize(page)))); + (unsigned long) BTMaxItemSize(page)), + errhint("Values larger than 1/3 of a buffer page cannot be indexed\n" + "Consider a separate column containing an MD5 hash of the value\n" + "or use full text indexing."))); /* * Determine exactly where new item will go. diff --git a/src/backend/access/nbtree/nbtsort.c b/src/backend/access/nbtree/nbtsort.c index 115708b7809..edad76b9f2f 100644 --- a/src/backend/access/nbtree/nbtsort.c +++ b/src/backend/access/nbtree/nbtsort.c @@ -56,7 +56,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/access/nbtree/nbtsort.c,v 1.91 2005/06/06 20:22:57 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/access/nbtree/nbtsort.c,v 1.92 2005/08/10 21:36:45 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -498,7 +498,10 @@ _bt_buildadd(BTWriteState *wstate, BTPageState *state, BTItem bti) (errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED), errmsg("index row size %lu exceeds btree maximum, %lu", (unsigned long) btisz, - (unsigned long) BTMaxItemSize(npage)))); + (unsigned long) BTMaxItemSize(npage)), + errhint("Values larger than 1/3 of a buffer page cannot be indexed\n" + "Consider a separate column containing an MD5 hash of the value\n" + "or use full text indexing."))); if (pgspc < btisz || pgspc < state->btps_full) { |