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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| |||
| "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 |
| |||
| 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 [mailto 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 ************************************************** ******************** |
| ||||
| 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 > |