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