works fine....
contrib_regression=# select count(*) from test_data ;
 count
-------
   250
(1 row)

contrib_regression=# create index test_data_index on test_data using gist( loc 
);
CREATE INDEX


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

--
Teodor Sigaev                                   E-mail: [EMAIL PROTECTED]
                                                   WWW: http://www.sigaev.ru/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to