Unix Technical Forum

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

This is a discussion on Interface of the R-tree in order to work with postgresql within the pgsql Novice forums, part of the PostgreSQL category; --> Hi everybody! I'm Jorge from Peru -> South America I'm new in the list, and this is my first ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 11:14 PM
jorge alberto
 
Posts: n/a
Default 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 11:14 PM
Tom Lane
 
Posts: n/a
Default Re: Interface of the R-tree in order to work with postgresql

"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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-17-2008, 11:15 PM
Tomeh, Husam
 
Posts: n/a
Default Re: Interface of the R-tree in order to work with


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

http://postgis.refractions.net/
http://postgis.refractions.net/docs/

--
Husam


________________________________

From: pgsql-novice-owner@postgresql.org
[mailtogsql-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
************************************************** ********************

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-17-2008, 11:15 PM
jorge alberto
 
Posts: n/a
Default Re: Interface of the R-tree in order to work with postgresql

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
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:19 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com