Re: NEED HELP !
От | Sergej Galkin |
---|---|
Тема | Re: NEED HELP ! |
Дата | |
Msg-id | dfebc1f11001131056m139a2ab5pabe21e6717346082@mail.gmail.com обсуждение исходный текст |
Ответ на | NEED HELP ! (Sergej Galkin <sergej.galkin@gmail.com>) |
Ответы |
Re: NEED HELP !
|
Список | pgsql-hackers |
I want to add than I have a piece of my code that looks very strange <br /><br /><div style="margin-left: 80px;">Datum gist_mov_penalty(PG_FUNCTION_ARGS)<br/>{<br /> GISTENTRY *origentry = (GISTENTRY *) PG_GETARG_POINTER(0);<br /> GISTENTRY*newentry = (GISTENTRY *) PG_GETARG_POINTER(1);<br /> float * result = (float *) PG_GETARG_POINTER(2);<br /><b> moving_object *orig = &(*origentry).key;<br /> make_now(orig);<br /> moving_object *new = &(*origentry).key;<br/> make_now(new);</b><br /><br /><br /><br /></div><div style="margin-left: 40px;">Is everythingok in this code ??<br /><br /></div><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 /><blockquoteclass="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 am a student-magister and I'm writting my magister work. I realized gist indexTPR tree - it is like a simple R tree but moving :)<br /> Everything is compiling ok, I creating table and index, butafter 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 where mov_obj ~ box '(0,0) (1,1)'</i><br /></div><br />I can not understandwhy DB is restarting ? It is restarting when SQL begins use index :(((<br /> Can anybody help me , I would by appretiateevery people who downloads my sources, try to deploy index and maybe solve where is the problem.<br /><br />Bestregards,<br /><font color="#888888">Sergej Galkin<br /></font></blockquote></div><br />
В списке pgsql-hackers по дате отправления: