[postgis-devel] [SoC] "Gsoc weekly report 6": Implement sp-gist clustering in PostGIS and cartoDB

[mohit kumar]

hi strk,
Now make check is giving no errors. I used "box2df" in place of "geometry".


On Mon, Jun 30, 2014 at 3:06 PM, Sandro Santilli <strk at cartodb.com> wrote:

> On Mon, Jun 30, 2014 at 12:18:23AM +0530, mohit kumar wrote:
>
> > *What do I plan on doing next week?*
> >
> > Work on building the storage type for access method "sp-gist"
>
> Mohit, the storage type you don't have to "build" it.
> All types are built, you only have to specify which
> type has to be used by the operatoc class.
>
> The problem you were having is that you tried to use
> a storage type of "box2df" while associating the opclass
> to the type "geometry". The error message told you this
> mixing of types is not supported by the "spgist" access
> method. So you just have to pick one type and use it for
> both storage type and target type.
>
> Picking "geometry" would make the index bigger.
> Picking anything else would make usage a bit convoluted as you
> would not be able to index a "geometry" column but you'd have
> to index the output of a function applied to it, returning the
> choosed type.
>
> I'd go with "box2df" for a start.
>
> --strk;
>
>  ()  ASCII ribbon campaign  --  Keep it simple !
>  /\  http://strk.keybit.net/rants/ascii_mails.txt
>



-- 
Mohit Kumar
+91-970-3840-175
Lab For Spatial Informatics
International Institute of Information Technology
Hyderabad, India
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140702/69a2ac98/attachment.html>