The inclusion of access/tuptoaster.h in access/common/indextuple.c brought
in the define of TOAST_INDEX_HACK which compresses large index entries.
When this was removed the entries were no longer compressed which caused
btree_gist to fail.
Kris Jurka
Index: src/backend/access/common/indextuple.c
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/access/common/indextuple.c,v
retrieving revision 1.78
diff -c -r1.78 indextuple.c
*** src/backend/access/common/indextuple.c 14 Jul 2006 14:52:16 -0000
1.78
--- src/backend/access/common/indextuple.c 14 Jul 2006 18:05:26 -0000
***************
*** 18,24 ****
#include "access/heapam.h"
#include "access/itup.h"
!
/* ----------------------------------------------------------------
* index_ tuple interface routines
--- 18,24 ----
#include "access/heapam.h"
#include "access/itup.h"
! #include "access/tuptoaster.h"
/* ----------------------------------------------------------------
* index_ tuple interface routines
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match