Обсуждение: Interface of the R-tree in order to work with postgresql

Поиск
Список
Период
Сортировка

Interface of the R-tree in order to work with postgresql

От
"jorge alberto"
Дата:
Hi everybody!
I'm Jorge from Peru -> South America
I'm new in the list, and this is my first post:

I want to know how can I add a new spatial access method into the postgresql, I mean where can i find the .h that describes the
interface that a spatial access method, like the R-tree, must have in order to work with postgresql.

I think that for me to understand how postgresql works with spatial access methods, like the R-tree, I need to find a .h or .c to begin
reading the code, so can you tell me where to start?

I hope you can help me
thanks in advance
regards


Re: Interface of the R-tree in order to work with postgresql

От
Tom Lane
Дата:
"jorge alberto" <jorge.is.a.geek@gmail.com> writes:
> I want to know how can I add a new spatial access method into the
> postgresql,

Developing a new index access method is hardly a novice-level task.
Are you sure you need to do that?  Perhaps you can accomplish what
you want by making a new datatype and interfacing it to GiST indexes.
That's still a pretty large chunk to bite off, but there are examples
available --- look into the contrib/ directory to find existing add-on
datatypes that have GiST indexing capability.  The documentation for
this area is weak.  Be prepared to read source code ...

            regards, tom lane

Re: Interface of the R-tree in order to work with

От
"Tomeh, Husam"
Дата:

Jorge, you may want to also check out PostGIS which specially enables postgres server.
 
 
--
  Husam
 


From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of jorge alberto
Sent: Wednesday, October 04, 2006 8:31 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Interface of the R-tree in order to work with postgresql

Hi everybody!
I'm Jorge from Peru -> South America
I'm new in the list, and this is my first post:

I want to know how can I add a new spatial access method into the postgresql, I mean where can i find the .h that describes the
interface that a spatial access method, like the R-tree, must have in order to work with postgresql.

I think that for me to understand how postgresql works with spatial access methods, like the R-tree, I need to find a .h or .c to begin
reading the code, so can you tell me where to start?

I hope you can help me
thanks in advance
regards


**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                                                                                                         FADLD Tag
**********************************************************************

Re: Interface of the R-tree in order to work with postgresql

От
"jorge alberto"
Дата:
hi,  thanks for writing
 
I'm doing research about spatial access methods( reading a lot of papers and programming a lot too ) but also I want to know how can I add my new data structure( if someday i get it, of course =) ) in the postgresql;in order to do so, first I have to know how the R-tree works with the postgreql, I mean, I already know the R-tree algorithms but I don't know how does the R-tree interfaces with postgresql.
 
I hope you can help me
regards Jorge
 
On 10/4/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"jorge alberto" < jorge.is.a.geek@gmail.com> writes:
> I want to know how can I add a new spatial access method into the
> postgresql,

Developing a new index access method is hardly a novice-level task.
Are you sure you need to do that?  Perhaps you can accomplish what
you want by making a new datatype and interfacing it to GiST indexes.
That's still a pretty large chunk to bite off, but there are examples
available --- look into the contrib/ directory to find existing add-on
datatypes that have GiST indexing capability.  The documentation for
this area is weak.  Be prepared to read source code ...

                       regards, tom lane