I debugged index with gdb and found that it is segmentation fault in my procedure named <b>gist_mov_consistent</b> it
isonly 7 lines. So I think it is worth to publish it to public, <br /><br /><i><br /></i> <i>Datum
gist_mov_consistent(PG_FUNCTION_ARGS)</i><br/><i>{</i><br /><i> GISTENTRY *entry = (GISTENTRY
*)PG_GETARG_POINTER(0);</i><br/><i> BOX *query = PG_GETARG_BOX_P(1);</i><br /><i> StrategyNumber strategy =
(StrategyNumber)PG_GETARG_UINT16(2);</i><br/><i> </i><br /><i> if (DatumGetMovP(entry->key) == NULL || query
==NULL)</i><br /><i> PG_RETURN_BOOL(FALSE);</i><br /><i> </i><br /><i>
PG_RETURN_BOOL(obj_contains(DatumGetMovP(entry->key),query));</i><br /><i>}</i><br /><br />Do you have any ideas
whereis the problem ? :)<br /><br />Best regards,<br />Sergej Galkin<br /><br /><div class="gmail_quote">On Wed, Jan
13,2010 at 8:42 PM, Sergej Galkin <span dir="ltr"><<a
href="mailto:sergej.galkin@gmail.com">sergej.galkin@gmail.com</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello all,<br /><br />I
ama student-magister and I'm writting my magister work. I realized gist index TPR tree - it is like a simple R tree but
moving:)<br /> Everything is compiling ok, I creating table and index, but after whese code - DB is restarting :(((<br
/><b><br/></b><div style="margin-left: 40px;"><i>set enable_seqscan = false<br />select * from table_of_moving_objects
wheremov_obj ~ box '(0,0) (1,1)'</i><br /></div><div class="im"><br />I can not understand why DB is restarting ? It is
restartingwhen SQL begins use index :(((<br /> Can anybody help me , I would by appretiate every people who downloads
mysources, try to deploy index and maybe solve where is the problem.<br /><br /></div>Best regards,<br /><font
color="#888888">SergejGalkin<br /></font></blockquote></div><br />
