Skip site navigation (1) Skip section navigation (2)

Re: NEED HELP !

From: Sergej Galkin <sergej(dot)galkin(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: NEED HELP !
Date: 2010-01-13 19:46:22
Message-ID: dfebc1f11001131146o2cf28d38p22dad636ad8802f3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
And
*int obj_contains(moving_object *a, BOX *b)
{

    if (b->low.x > a->x_low)
        return 0;
    if (b->low.y > a->y_low)
        return 0;
    if (b->high.x < a->x_high)
        return 0;
    if (b->high.y < a->y_high)
        return 0;
    return 1;
}*
this is the procedure obj contains

On Wed, Jan 13, 2010 at 8:56 PM, Sergej Galkin <sergej(dot)galkin(at)gmail(dot)com>wrote:

> I want to add than I have a piece of my code that looks very strange
>
> Datum gist_mov_penalty(PG_FUNCTION_ARGS)
> {
>     GISTENTRY *origentry = (GISTENTRY *) PG_GETARG_POINTER(0);
>     GISTENTRY *newentry  = (GISTENTRY *) PG_GETARG_POINTER(1);
>     float * result = (float *) PG_GETARG_POINTER(2);
> *     moving_object *orig =  &(*origentry).key;
>     make_now(orig);
>     moving_object *new = &(*origentry).key;
>     make_now(new);*
>
>
>
> Is everything ok in this code ??
>
>
> On Wed, Jan 13, 2010 at 8:42 PM, Sergej Galkin <sergej(dot)galkin(at)gmail(dot)com>wrote:
>
>> Hello all,
>>
>> I am a student-magister and I'm writting my magister work. I realized gist
>> index TPR tree - it is like a simple R tree but moving :)
>> Everything is compiling ok, I creating table and index, but after whese
>> code - DB is restarting :(((
>> *
>> *
>> *set enable_seqscan = false
>> select * from table_of_moving_objects where mov_obj ~ box '(0,0) (1,1)'*
>>
>> I can not understand why DB is restarting ? It is restarting when SQL
>> begins use index :(((
>> Can anybody help me , I would by appretiate every people who downloads my
>> sources, try to deploy index and maybe solve where is the problem.
>>
>> Best regards,
>> Sergej Galkin
>>
>
>

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2010-01-13 19:46:41
Subject: Re: [PATCH] remove redundant ownership checks
Previous:From: Sergej GalkinDate: 2010-01-13 19:43:03
Subject: Re: NEED HELP !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group