When grilled further on (Tue, 08 Nov 2005 11:12:04 -0500), Tom Lane <[EMAIL PROTECTED]> confessed:
> Teodor Sigaev <[EMAIL PROTECTED]> writes:
> > Layout of GIST_SPLITVEC struct has been changed from 8.0, I'm afraid that
> > old
> > .so is used. spl_(right|left)valid fields was added to GIST_SPLITVEC.
>
> Does look a bit suspicious ... Robert, are you *sure* you've got the
> right version of pgsphere linked in? Did you compile it against the
> right set of Postgres header files?
>
Strings on pg_sphere.so does contain /usr/local/pgsql810/lib.
I've attached a small dump file that when I create an index on the table, it
fails. It works on 225 entries, but failed on 250. Don't know if this is data
dependent or size. Is that a page boundary? It seems to me that unless the
right/left stuff doesn't come into play for all indexes, that stuff is built
correctly.
Dump command:
/usr/local/pgsql810/bin/pg_dump -F c -p 5433 -d tassiv -t test_data -f
index_problem.dump
Created the table and index by:
tassiv=# SELECT loc into test_data from catalog limit 250;
tassiv=# create index test_data_index on test_data using gist( loc );
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
tassiv=# \d test_data
Table "public.test_data"
Column | Type | Modifiers
--------+--------+-----------
loc | spoint |
Cheers,
Rob
--
19:51:58 up 37 days, 12:26, 6 users, load average: 2.15, 2.39, 2.41
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004
index_problem.dump
Description: Binary data
pgp6Rs93Q3Tpv.pgp
Description: PGP signature
