From 237be3cc2945ad5216bf227a1ee2c47a29818167 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 10 Aug 2005 21:36:46 +0000 Subject: Add hints to cases where indexes fail because of values that are too long. --- src/backend/access/rtree/rtree.c | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/backend/access/rtree/rtree.c') diff --git a/src/backend/access/rtree/rtree.c b/src/backend/access/rtree/rtree.c index e9eaa1941d6..3b96b9ebe2d 100644 --- a/src/backend/access/rtree/rtree.c +++ b/src/backend/access/rtree/rtree.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/access/rtree/rtree.c,v 1.90 2005/06/06 17:01:22 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/access/rtree/rtree.c,v 1.91 2005/08/10 21:36:46 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -733,7 +733,8 @@ rtpicksplit(Relation r, (errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED), errmsg("index row size %lu exceeds rtree maximum, %lu", (unsigned long) newitemsz, - (unsigned long) RTPageAvailSpace))); + (unsigned long) RTPageAvailSpace), + errhint("Values larger than a buffer page cannot be indexed."))); maxoff = PageGetMaxOffsetNumber(page); newitemoff = OffsetNumberNext(maxoff); /* phony index for new -- cgit v1.2.3