Re: NEED HELP ! - Mailing list pgsql-hackers

From Sergej Galkin
Subject Re: NEED HELP !
Date
Msg-id dfebc1f11001131056m139a2ab5pabe21e6717346082@mail.gmail.com
Whole thread Raw
In response to NEED HELP !  (Sergej Galkin <sergej.galkin@gmail.com>)
Responses Re: NEED HELP !  (Sergej Galkin <sergej.galkin@gmail.com>)
List 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 by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: [PATCH] remove redundant ownership checks
Next
From: Andres Freund
Date:
Subject: Re: Hot Standby and query cancel