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 18:56:25
Message-ID: dfebc1f11001131056m139a2ab5pabe21e6717346082@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

  • NEED HELP ! at 2010-01-13 18:42:22 from Sergej Galkin

Responses

pgsql-hackers by date

Next:From: Andres FreundDate: 2010-01-13 18:58:32
Subject: Re: Hot Standby and query cancel
Previous:From: Jaime CasanovaDate: 2010-01-13 18:49:45
Subject: Re: [PATCH] remove redundant ownership checks

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